Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Ryss Unger
  Where is Ryss Unger?
 Cape Town
 South Africa
 Ryss Unger
 To: Paul Brown
 Paul Brown
Subject: RE: Slow
Thread ID: 350 Message ID: 357 # Views: 6 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Thursday, May 24, 2001 4:05:11 PM         

> > 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.
> Paul

Hi Tom,
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.



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