Pippin - did you set the memory configuration for your db to one of the
high modes? When I run the query in firefox with the sqlite manager,
execution time drops from >400s to about 60s when using memory as the
temporary storage (which is one of the tweaks the high memory setting
applies). All the disk IO is gone.
That said it's still 5-6x slower than without the library_id. The
biggest difference between your library and mine probably is the number
of contributors (12k vs 2k). If I don't join them in the query, we're
down to 200ms...
Now I'll have to figure out how we could optimize this.
--
Michael
_______________________________________________
beta mailing list
[email protected]
http://lists.slimdevices.com/mailman/listinfo/beta
