Subject | Locate problems |
---|---|
Author | antoni.aloy@viajesastral.com |
Post date | 2002-11-26T09:50:52Z |
Hi!
I'm trying to use locate to go to a record but it's terrybly slow as it
tries to fecth all the records (its a 10.000 records table and the
connection is a ISDN 128K).
I have the table mapped to a IB_Query (QTickets) indexed on the fields I'm
searching on (serie, numero).
QTickets.Locate('SERIE,NUMERO',VarArrayOf([serie,numero]),[])
What could be happenning? Is there a more efficient way to do that?
============================================
Antoni Aloy López
IT MyTravel Incoming Services Spain
Tel. +034 971221097
Fax. +034 971288295
Member of MyTravel Group
============================================
I'm trying to use locate to go to a record but it's terrybly slow as it
tries to fecth all the records (its a 10.000 records table and the
connection is a ISDN 128K).
I have the table mapped to a IB_Query (QTickets) indexed on the fields I'm
searching on (serie, numero).
QTickets.Locate('SERIE,NUMERO',VarArrayOf([serie,numero]),[])
What could be happenning? Is there a more efficient way to do that?
============================================
Antoni Aloy López
IT MyTravel Incoming Services Spain
Tel. +034 971221097
Fax. +034 971288295
Member of MyTravel Group
============================================