Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Want speed up sql select
Message
From
03/07/1997 18:56:05
 
 
To
03/07/1997 17:49:09
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00038612
Message ID:
00038616
Views:
37
Just for the record, try:

select * from postcode where m.addr $ address m.addr

It might be a little faster...

Be careful, this is case sensitive.

Vlad

>I have two sql statement:
>select * from postcode where ascen(addr_array,address)
>This take several seconds each time.
>
>The other sql statement:
>select * from postcode where atc(address,m.addr)#0
>also take several seconds.
>
>I want it take up to one second only, any suggestions?
Previous
Reply
Map
View

Click here to load this message in the networking platform