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?
oh, what is the fastest way to write good program?