Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Paul Brown
 Paul Brown
 To: Thomas Holt
  Where is Thomas Holt?
 United Kingdom
 Thomas Holt
Subject: RE: Slow
Thread ID: 350 Message ID: 352 # Views: 3 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Thursday, May 24, 2001 6:59:56 AM         

> Hello
> I have a table with 66000 records and 30 odd fields this is how its been from the early days when someone with no knowlege made the tables, how can i speed it up by breaking it down into several tables and how do i do this, plus are there any other suggestions.
> Tom

What is slow about the table? Updating, deleting, querying?
66000 is not a lot of records. If your queries are slow, you probably need to create indexes on the appropriate fields. Make sure all your tables have a primary key (type Integer) and create a primary index on it. Integer keys are the fastest way to join 2 tables.



Slow Posted by Thomas Holt @ 5/24/2001 5:11:25 AM
RE: Slow Posted by Paul Brown @ 5/24/2001 6:59:56 AM
RE: Slow Posted by Ryss Unger @ 5/24/2001 4:05:11 PM