Refreshing an SQL Database

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?

Thanks!

-Jeff
LVL 1
FCouplesAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
SethiConnect With a Mentor Commented:
Use Recordset.Requery method
0
 
FCouplesAuthor Commented:
That also freezes it as well :(
0
 
SethiCommented:
Hmm...then I am short of ideas
0
 
FCouplesAuthor Commented:
i ended up using individual queries instead of searching through the whole database with the rs search command.  Your answer lead me to that conclusion, so points go to you.  Thanks!

-Jeff
0
 
SethiCommented:
Thanks :-)
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.