Foxpro Matt Slay, Ph. CThe problem initially posted to Universal Thread 2. I have a VFP9 app that runs against Sql Server. When I run the forms inside the Fox. Try or Buy The DWG to PDF Control Component is licensed as DEVELOPER LICENSE, SERVER LICENSE and SITE LICENSE. Developer License One. Freeprogrammingbooks books Freely available programming books. Learn Foxpro Programming Pdf' title='Learn Foxpro Programming Pdf' />Download Barcode Fonts including Code 39, Code 128, DataMatrix, Codabar, Postnet, Intelligent Mail, OneCode, PDF417, UPC, EAN, Interleaved 2 of 5, MICR, OCR and many. Learn Foxpro Programming Pdf' title='Learn Foxpro Programming Pdf' />Pro IDE, running against the production Sql Server database located on a central server down the hall i. NOT on my local developer machine, all the forms load up and run very quickly. However, once compiled into an exe and running from the same developer machine, the forms take about FIVEtimes as long to load up. This is very consistent across all forms. Learn Foxpro Programming Pdf' title='Learn Foxpro Programming Pdf' />The difference is 1. IDE versus 7 seconds load time when running from an EXE. Is there a particular reason that forms would run more quickly inside the Fox. Pro IDE than when compiled into an EXE The solution. Some background A basic form in Visual Fox. Pro 9 my app will create between 3. Business Objects when it loads up yes, those really cool kind of Sql Server Business Objects based on of the West Wind ww. Business framework. In our system, like most others, an Order has a Customer, and Contact, and Ship. To. Address, and vast collection of child items i. Line. Items, Labor. Records, Material. Records, Shipping. Tickets, Invoices, etc. So you can see its a very robust businessentity model and very oneof those items I listed has its own formal Business Object to load the respective data and do various pieces of work on the data. Each business object is a separate PRG Job. Customer. prg, Contact. Job. Line. Items. Job. Shipping. Tickets. You get the picture. In all, I have about 4. Uniport System PowerPoint Presentations PPT View powerPoint Presentations PPT about Uniport System. The list of programming languages is comprised of all languages implemented in a compiler or an interpreter, in alphabetical order. And for recent languages. Discussion forums for open issues and questions concerning database tools, data access components and developer tools from Devart. ActiveVFP is a completely free and open source project for creating web applications with Visual Foxpro. Why use PHP Easy yet powerful Foxpro web development. Businesss Objects, each in a separate prg file. Each UI form uses a loader function to instantiate each needed Business Object and all other related Business Objects. The loader functions make a simple call like. Job New. ObjectJob, Job. Install Flash Player Linux Chromium Flash'>Install Flash Player Linux Chromium Flash. Return lo. Joblo. Amish Breeding Program. JobNew. ObjectJob,Job. Returnlo. Job. Well, guess what I learned. If you call New. Object in this manner from within the Fox. Pro IDE, it runs in about. Thats plenty fast enough for me and my users, but my users dont run the app from my IDE. They use a compiled EXE app running and in that case, the same New. Object call takes. Please note that is times longer for each callNow remember that my forms will typically call this function about 3. VFP IDE, but it takes 7 8 seconds when running from an EXE. Are you kidding me What is going on BTW I discovered this using the Coverage Profiler and a good bit of snooping around in the log results. So, the offense that I independently discovered here is that New. Object is really slow when running inside of an EXE, but very fast when running in the IDE. Cant explain that, but its true. The remedy was to get away from New. Object in by BO factory and use Create. Object instead, which also requires the prgs to be loaded into memory by way of SET PROCEDURE. So, instead of making 5. Set Procedure calls, I wrote a build task which merges all the separate prgs into a single prg and I added that to the project as an included file, then I added a Set Procedure command for this file in the app bootup sequence. Set Procedure To Business. Objects Additive. Set Procedure To. Business. Objects Additive. I then changed my BO loader function to use Create. Object instead of New. Object. lo. Job Create. ObjectJob. Return lo. Joblo. JobCreate. ObjectJobReturnlo. Job. And, boom, I now get lightening fast creation of each BO even when running in the compiled EXE, and the form now loads in 1 second or so. Users Happy. Now, apparently I am not the only one who has ever discovered this oddity before maybe you already knew it yourself as well, but as I was honing in on what I though the issue was, and what I thought the remedy would require, I happened to do a little Googling and found a 1. Rick Strahl who had himself dealt with this issue before, and confirmed the same exact results and remedy that I landed on. Here is his post http www. Show. Entry. blog You can also see more discussion on this topic at Fox. Wikis. com http fox. WikiNew. Object. Wow This was a fun day. I love killing these little pests. Update Sys2. 45. User Walter Meester posted a reply on UT asking if I had tried using Sys2. Specifies how an application searches for data and resources such as functions, procedures, executable files, and so on. From the VFP Help. Search along path and default locations before searching in the application. Default. 1 Search within the application for the specified procedure or UDF before searching the path and default locations. Parameters 0Search along path anddefaultlocations before searching inthe application. Default1Search within the application forthe specified procedure or. UDF before searching the path anddefaultlocations. So, I went back to the New. Object way, and added the SYS2. Result Using Sys2. New. Object does help a little bit when running inside an exe, UT it is still slower than using SET PROCEDURE along with Create. Object. There are very distinctive and noticeable speed differences 1st Place SET PROCEDURE Create. Object 1. 4 seconds. Place Sys2. 45. New. Object 5 Seconds. Place New. Object alone leaving Sys2. I hope this information helps your app performance in some way. Here are the results I found from the Coverage Profiler for 1st Place and 3rd Place above. I did not go back and run 2nd Place through the coverage proviler, but you can perceive where it would fall based on the time results listed above.