-
November 17th, 2009, 01:57 AM
#1
Problem in CRecordset::Open.
Hi all,
i m using Access databse and ODBC connection to connectivity with the database.
there is number of tabels approx 36 tabels.
Each n every table have separate CRecordset derived class.
at one point when i m using many of these table,firstly its working fine but after some time
CRecordset::Open takes so much time to open recordset and between this duration application looks like not responding.
please help me how can i resolve this.
please help for this.
thanks in advance.
IN A DAY, WHEN YOU DON'T COME ACROSS ANY PROBLEMS - YOU CAN BE SURE THAT YOU ARE TRAVELLING IN A WRONG PATH
-
November 17th, 2009, 09:53 AM
#2
Re: Problem in CRecordset::Open.
No telling what's going on. If your query returns a lot of records, try using a dynaset instead of a snapshot.
-
November 18th, 2009, 12:20 AM
#3
Re: Problem in CRecordset::Open.
I m already using dynaset.
IN A DAY, WHEN YOU DON'T COME ACROSS ANY PROBLEMS - YOU CAN BE SURE THAT YOU ARE TRAVELLING IN A WRONG PATH
-
November 18th, 2009, 12:45 AM
#4
Re: Problem in CRecordset::Open.
If the database fetch operation takes a while and you are doing it in the main UI thread, it's going to make the app non-responsive.
To fix this, put the database operation into a secondary thread.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|