At 07:53 21/03/2012, Max Vlasov wrote:
On Wed, Mar 21, 2012 at 1:33 AM, Tim Morton <t...@preservedwords.com> wrote:
> So it seems the index is no help;
>
Are you sure you did as Simon explained?
Becausem my tests shows the trick works... (sqlite 3.7.10)
The trick works, but i think he didn't timed what he should timed.
He did:
cur.execute('SELECT topics FROM dict')
start = time.time()
for item in cur:
tmp.append(item[0])
print time.time() - start, 'get WL'
So he timed getting the data from the python cursor and moving to a
python array. I think he should time:
start = time.time()
cur.execute('SELECT topics FROM dict')
for item in cur:
tmp.append(item[0])
print time.time() - start, 'get WL'
Including the SELECT because that's where the trick work.
The timing was unaffected by sqlite and system cache since the db was
reopened with a special trick on Windows forcing it to clear cache for this
file
Max
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users