That's exactly why. You are fetching a lot of data which blocks your app.Originally Posted by TorAn
The "Q"
Re: Slow ODBC driver or programming error?
That's exactly why. You are fetching a lot of data which blocks your app.
Your biological and technological distinctiveness will be added to our own. Resistance is futile.
Please ask Qt related questions on the forum and not using private messages or visitor messages.
Intermediate user
Re: Slow ODBC driver or programming error?
1017 records is a lot of data?
When this call is executed on the machine where db is located it takes about 2 secs.
When it is executed on the LAN it takes about 4 seconds. When I am on WAN (public), it takes literally 5 minutes. The same sql request through SQL Management studio takes 2 secs on LAN and 2-4 secs on WAN.
The "Q"
Re: Slow ODBC driver or programming error?
Blame your ODBC driver. Qt driver is optimized for what it does, if you want to force it to load all the rows even if it doesn't want to, you probably get additional queries which slow down everything. Use a better driver or skip the unnecessary while loop.
Your biological and technological distinctiveness will be added to our own. Resistance is futile.
Please ask Qt related questions on the forum and not using private messages or visitor messages.
Intermediate user
Re: Slow ODBC driver or programming error?
That's what I am doing.Blame your ODBC driver
Which driver do you recommend? FreeTDS?
The "Q"
Re: Slow ODBC driver or programming error?
Use the driver most fit for your database. However I would first think whether I really needed this while loop. It seems not necessary.
Your biological and technological distinctiveness will be added to our own. Resistance is futile.
Please ask Qt related questions on the forum and not using private messages or visitor messages.
Posting Permissions
Reply With Quote
Bookmarks