Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Speeding up query
Message
From
16/05/2008 13:05:31
 
 
To
16/05/2008 11:10:06
Chris Ross
Lothian Valuation Joint Board
Edinburgh, United Kingdom
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
01317018
Message ID:
01317672
Views:
10
>I've updated my code and the search in general is much faster than before except in the instance of searching on Streetname or town only (These fields have indices set).
>
>A streetname or Town only search can take 30-45 seconds to return the results. There are 450,000 property records and about 30000 master level records but this seems excessive?
>

What does SYS(3054) tell you?


Tamar
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform