mir amicitas schrieb:
> With sqlite3 or apsw things are much more tolerable, though if any one has
> ideas on how to make the extraction even faster I would love to here them.
> What I am doing for now is to use:
>
> results = [row for row in self.cursor]
Try:
results = list(self.curso
On 2008-10-08, mir amicitas wrote:
> I am trying to use SQLite in a PyQt4 application. I am running into a
> problem where it is taking a really long time to get the data out of
> the QSqlQuery object after a query is completed. Here is a code
> snippet with the relevant parts:
>
>
I took your suggestion and tried out sqlite3 and also apsw. Using either of
these modules the unpacking time is reduced to 1-2 seconds.
Furthermore just cycling through the results takes 1-1.5 seconds, meaning
that adding the results to a list is much quicker than using QSqlQuery (
less than 1 se
mir amicitas schrieb:
> I am trying to use SQLite in a PyQt4 application. I am running into a
> problem where it is taking a really long time to get the data out of
> the QSqlQuery object after a query is completed. Here is a code
> snippet with the relevant parts:
>
>
I am trying to use SQLite in a PyQt4 application. I am running into a
problem where it is taking a really long time to get the data out of
the QSqlQuery object after a query is completed. Here is a code
snippet with the relevant parts:
##
