Refreshing an SQL Database
Posted on 2004-09-11
I have a program that accesses an SQL database on a linux server. It connects fine and displays the database correctly, the only problem i'm having is when I have the database refresh. The function i'm using is datPrimaryRS.Recordset.Resync, and when it does this it freezes the program for about 5 seconds. I don't want it to freeze for 5 seconds, and I want it to resync the database faster than that as well. I don't see why it has to download the entire database again (if that's what it's doing), it just needs to look for changed/new records. Any ideas of anything else I could try?