TADOTable, Seek and clUseServer how to combine?

Is it possible to use the seek function when the cursor location is set to clUseServer in Delphi's ADOTable? I know that it is possible to use locate function instead but it i开发者_运维问答s a lot slower than the seek function.

If you use Locate, Seek (or similar function) you are retrieving all records on local. If you want to use Server Cursor (clUseServer) you must use SQL to search registers.
If you are using "Incremental Search" or trying use it, this is not a good idea in big tables with 50k records.

Regards