From: Paul Brown
To: Thomas Holt
General VFP Topics
Thursday, May 24, 2001 6:59:56 AM
This message was rated by:
> 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.
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.
Posted by Thomas Holt @ 5/24/2001 5:11:25 AM
Posted by Paul Brown @ 5/24/2001 6:59:56 AM
Posted by Ryss Unger @ 5/24/2001 4:05:11 PM