Hi guys, I'm currently working with a pretty gigantic database (116 Gb at the moment, and growing). Performing a simple SELECT routine with one filter takes between 7 and 15 minutes, which is starting to become a problem. The command I'm using is the following:
SELECT NVERTS FROM ToricCY WHERE H11=2; Pretty basic. I just want the NVERTS column of the table ToricCY where another column labeled H11 is 2, nothing fancy. Because of the huge size of the database, I would expect it to take a while, but I was wondering if you guys have any recommendations on how to speed it up (if possible). Also, because this problem will only get worse as the database grows, I'm looking for alternative approaches to storing this data. Does anyone have experience working with databases this big? Thanks! Best, Ross _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
