Application running slow after build... 1

[Guest_imported]

Hi,

I just developed a litle application retreiving information from a FoxPro DB. While I succeeded to make it run reasonably fast during development, it is running extremely slow after I built it. A set of queries could take a maximum of 2 seconds in the development environment while it takes 1.5 minute after built...

Can anybody see why?

Thanks for the help.

Fred.

 

[ramani]

Hi,
This could be related to your environment. I suggest you to copy the Config.fp or Config.fpw from your development directory or the FoxPro original directory ... to .... the runtime application directory. This could solve your problem. You can toy with your values in that file to suit the run time environment...specifically related to memory.
ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[Guest_imported]

Thanks, it looks fine now.

Here is an other one. When I start twice the application, I have the following error message:

"... File access is denied"

The tables I imported in the Data Environment are all opened as read only and exclusif is set to false.

Any idea why??

 

[rgbean]

Additionally, it would be useful to know the version of FoxPro that you are using (FP 2.0, FPD/W 2.x) including the patch level. Also what OS are you running and how much memory does the system have? Did move the data from a local system to a "network" drive?

Rick

 

[ramani]

Hi,
Regarding file open error....
Some where along the line you have indirectly set the exclusivity.. To overcome this, put the code.. in the main prg along with other set commands...
SET EXCLUSIVE OFF
this shall solve your problem.

ramani :-9
(Subramanian.G)
FoxAcc
ramani_g@yahoo.com
LET KNOW IF THIS HELPED. ENOUGH EXPERTS ARE HERE TO HELP YOU OUT! BEST OF LUCK

 

[tesar]

Denied access may cause also other programs than Fox,
e.g. editor. In my cause is it work with shared directory with Unix, as in moment create new file it lock directory..

 

[Guest_imported]

Thanks again folkes.