opensubscriber
   Find in this group all groups
 
Unknown more information…

c : conduit-dev-forum@news.palmos.com 12 February 2008 • 5:19AM -0500

Performing fast sync with Access database
by Jonathan Carse

REPLY TO AUTHOR
 
REPLY TO GROUP




Hi Everybody,

I have written a conduit that syncs between an Access database (using ADO)
and the palm database.
My problem is that since there is no way to retrieve only the "dirty"
records from an Access database (this is available only on SQL server), I am
forced to perform a slow sync on each sync (slow sync = comparison of all
records on both sides).

As my database grows well beyond 15,000 records, this is quite a speed
issue.
Has anyone encountered a problem like this? Is there an original idea out
there that might solve this case?

Thanks,

Jonathan

--
For information on using the ACCESS Developer Forums, or to unsubscribe, please see http://www.access-company.com/developers/forums/

Bookmark with:

Delicious   Digg   reddit   Facebook   StumbleUpon

Related Messages

opensubscriber is not affiliated with the authors of this message nor responsible for its content.