access faster a dbc in an intranet
access faster a dbc in an intranet
(OP)
Well i'm working in a company who has a sistem spread into an intranet and every day each node access the dbc which is in the server, but when they do this (i mean access and filter the tables from a dbc) this take several minutes, does someone know how to avoid this? i would really aprecciate some help.
Thank you¡¡
Thank you¡¡
RE: access faster a dbc in an intranet
Can you tell me how they are accessing. Whether it is thin client or front developed using visual foxpro.
If you are using DCOM objects to acccess your database this may very slow.
If you are using visual foxpro front end try sharing that server's Database directory then use in your application this may faster.
If you are using any combo box for a huge table this may also be slow down your form.
Dont' use SET FILTER TO command any where in your application, instead you can use SELECT SQL QUERY into a table.
These are all the practical problems I faced.
Hope one of the solution will solve your problem.
Logamoorthy
RE: access faster a dbc in an intranet
Is it a program that is accessing the DBCs?
Are the DBCs used to access remote data (not DBFs)?
If the answer to both is yes, you can create a small routine to run at program startup that copies the DBCs to each user's local Temp directory; it could check the timestamps on the files and only copy them if they are the same.
If you are primarily using shared DBFs (not remote data), then this approach won't work for you.
Robert Bradley
FoxDev - Visual FoxPro Development
RE: access faster a dbc in an intranet
John Durbin
ICQ VFP ActiveList #73897253
RE: access faster a dbc in an intranet
Steve Bowman
steve.bowman@wayservices.com