Paradox's FindNearest is faster than ADO MsAccess's Locate!!

From: Fatih Tolga Ata (fatihtolgaata_at_yahoo.com)
Date: 12/31/03 

Date: Wed, 31 Dec 2003 22:57:52 +0200

hi,
MsAccess support unicode chars, but paradox doesn't. However Paradox is
faster than ms access. I use access with this properties:
TableDirect:= True;
CursorLocation := clUseServer;
CursorType := ctKeyset;
Provider is "M$ OLE DB Provider for ODBC Drivers"
Also I use index. With this properties, ms Access's Locate function is about
4-5 sec. But paradox's FindNearest or Locate function is about 0,5 - 1 sec.
What can I do for improving Ms Access's performance like paradox.

sorry for my poor english.
Regards,

Relevant Pages

  • Re: Accessing All Tables In A DBC
    ... Is there an ODBC client or OLE DB provider for Paradox? ... There is no "native" way for FoxPro to read a .DB file. ... Rick ...
    (microsoft.public.fox.vfp.dbc)
  • Re: Retrieving errors OLEDB-MDAC
    ... So we changed the provider to SQLOLEDB and kept the same CursorLocation. ... "Error Handling in SQL Server - a Background" ...
    (microsoft.public.data.ado)
  • Re: VB6 Err 3251
    ... SQLOLEDB Provider and when Im trying to set the Index by using the code ... SQL Server and Im trying not to change the existing code so I need to use ... .CursorLocation = adUseServer ... Frankly you are better off biting the bullet and converting your code to ...
    (microsoft.public.vb.directx)