Hello Ross, Is H11 indexed? 15 minutes suggests to me that it's doing a linear scan and you need an index. I have databases that big and performance is pretty decent most of the time.
I'm sure the boys here will ask you for a schema probably an "explain" on the query. C Friday, October 24, 2014, 7:09:05 PM, you wrote: RA> Hi guys, RA> I'm currently working with a pretty gigantic database (116 Gb at the RA> moment, and growing). Performing a simple SELECT routine with one filter RA> takes between 7 and 15 minutes, which is starting to become a problem. The RA> command I'm using is the following: RA> SELECT NVERTS FROM ToricCY WHERE H11=2; RA> Pretty basic. I just want the NVERTS column of the table ToricCY where RA> another column labeled H11 is 2, nothing fancy. Because of the huge size of RA> the database, I would expect it to take a while, but I was wondering if you RA> guys have any recommendations on how to speed it up (if possible). RA> Also, because this problem will only get worse as the database grows, I'm RA> looking for alternative approaches to storing this data. Does anyone have RA> experience working with databases this big? RA> Thanks! RA> Best, RA> Ross RA> _______________________________________________ RA> sqlite-users mailing list RA> sqlite-users@sqlite.org RA> http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users -- Teg mailto:t...@djii.com _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
