Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Yuri Rubinov
  Where is Yuri Rubinov?
 Philadelphia
 Pennsylvania - United States
 Yuri Rubinov
 To: Chris Counts
  Where is Chris Counts?
 Bluefield
 West Virginia - United States
 Chris Counts
 Tags
Subject: RE: Speed Issues
Thread ID: 22205 Message ID: 22209 # Views: 14 # Ratings: 0
Version: Visual FoxPro 6 Category: Databases, Tables and SQL Server
Date: Friday, April 11, 2003 5:37:11 PM         
   


The short answer is that you need to rethink the approach how do you work with those tables: indexing, optimization, reducing the number of records by using views, etc... Details will depend on what actually is implementing by code and how.

> I'm sorry to bother you guys again, but I have a problem that I need to fix, and I don't know where to start. I wrote a database program using visual foxpro 6.0 that runs great at about 98 percent of our clients establishments. However, we have one client with a significant amount of data including some tables with close to a million records. The performance of this clients program is drastically worse than our other clients. Is there anything that I can try that will increase the speed of the program. If it helps our client is using a NT 4.0 server with 15 windows 98 workstations. I really appreciate any help that you guys can offer.
>
> Thanks,
> Chris Counts


COMPLETE THREAD

Speed Issues Posted by Chris Counts @ 4/11/2003 4:51:57 PM
RE: Speed Issues Posted by Yuri Rubinov @ 4/11/2003 5:37:11 PM
RE: Speed Issues Posted by Pete Sass @ 4/12/2003 2:18:05 AM
RE: Speed Issues Posted by Suresh @ 4/12/2003 11:20:52 AM
The Need for Speed ! lol Posted by Pete Sass @ 4/13/2003 5:28:00 AM
RE: The Need for Speed ! lol Posted by Chris Counts @ 4/15/2003 5:30:25 AM
RE: The Need for Speed ! lol Posted by Cheryl Bellucci @ 4/15/2003 7:45:33 PM
Segmenting the file with RushMore Posted by Rene Relucio @ 4/12/2003 2:04:20 PM
Take advantage of indeces and segmenting Posted by Rene Relucio @ 4/13/2003 8:15:57 AM