×
INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

access faster a dbc in an intranet

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¡¡

RE: access faster a dbc in an intranet

Hi Lennax,

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

More questions:
    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

The filter has got to be killing him.  Use SQL or paremetized views.  That's where I'd start

John Durbin


ICQ VFP ActiveList #73897253

RE: access faster a dbc in an intranet

Might just need an index to match the filter, under the circumstance this might speed up the filtering process without rewriting the app to use SQL cursors, Views ... there are many ways to do this right, but sometimes that is just not the possiable. I remember in the old days pre version 2 setting a filter was about the only way to seggregate a subset of data. The problem was under development working with small amounts of data most filter routienes worked fairly fast, now years later after the data has grown to many megabites it just don't work I test all apps with a larger then expected database I wrote a small program that builds a DBF of the needed size and stru and populates it with data so there are no suprizes later.

Steve Bowman
steve.bowman@wayservices.com

Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close