If you get a table scan then you are missing an index on the field from WHERE clause (likely 'group' column in your case).
The "Q"
Re: QT SQL advice
If you get a table scan then you are missing an index on the field from WHERE clause (likely 'group' column in your case).
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.
Novice
Re: QT SQL advice
I had a bug where I was creating the index. now its about 50% faster down to about 30-40ms from 80.
Running:
RHEL 5.4
Python 2.7.2
Qt 4.7.4
SIP 4.7.8
PyQt 4.7
Posting Permissions
Reply With Quote
Bookmarks