From: Ryss Unger
To: Paul Brown
General VFP Topics
Thursday, May 24, 2001 4:05:11 PM
This message was rated by:
> > 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.
Also let us know how big the fields are and the content.
I remeber seeing an eaxample from u (I think) where the fields contained info that I would have put in seperate fields.
As Paul states above indexes very important for Rushmore and queries.
Rushmore statesment must be able to indentify the relevant tag as well as be able to match structure of index to that of the query ( upper(name) in index to Upper(name) used in a query)
Processing data with left(gdgfd,15), substr(), dtoc, etc all slow the query time down and increase network traffic as all records need to be evaluated and therefore are required localy.
Hope you have some ideas here.
PS your suggestion on FAQ "highlight the text when the mouse moves over it" looks cool. Eric is evaluating it. Thanks for the input.
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