Julien,

This isn't a Delphi support list. The news server
news://forums.inprise.com has several newsgroups for Delphi database
programmers; and you can join a non-Borland mail list for such topics at
http://www.elists.org/mailman/listinfo/delphi-db

One comment I would make that is "on-topic" here is that Firebird and
Access are not architecturally comparable. About all they have in common
is that they both store data. Firebird, being a client/server database,
requires a substantially different approach in your application
design. Delphi's Locate() method, while fast on local tables, is a very
poor technique for client/server.

If you are interested, there is a paper "Moving to Client/Server" available
for download from http://www.ibobjects.com/TechInfo.html which discusses
some of the issues and techniques.

^heLen

>Hello,
>
>I've got a table Article and an index on the field CODE_BARRES of
>this table
>
>when I do
>
>QArticle.Locate('CODE_BARRES', ECodeBare.Text, []);
>
>the answer is very long (nearly one minute, and there's only 3000
>records in the table);
>
>With an Microsoft Access database everything works fine. And in the
>Delphi help I can read that the Locate function uses the fastest way
>to find a record.
>
>I created my index using
>create index I_CODEBARRES on Article(CODE_BARRES)
>
>Did I do something wrong ? Or do I have to specify (how ?) the index
>I want to use for my search?
>
>In advance Thank You
>
>Julien
>
>
>
>To unsubscribe from this group, send an email to:
>ib-support-unsubscribe@egroups.com
>
>
>
>Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/