General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
>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
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only