Hi all, i am an absolute newbi on sqlite. My problem, is that i have an db with 2 tables in one table i habe 300 records. in the other 1000000 records. when i did an select on the 300 records the table is quite fast, no problem. when i did an select on the big tabel a always get an failure from php max execution time. the big tabel have only 5 columns. the select looks for 2 colums like
SELECT * FROM bigtabel WHERE upper(value1) = 'value1' and upper(value2) = 'value2' i think thats not the problem. i usw iis and php 5.1.6. i know iis is big shit but in this case its so. when i did the select with my firefox plugin for sqlite i got the result whinin seconds. so i dont know whats the problem with the file. thanks for help! -- View this message in context: http://www.nabble.com/Failure-on-big-sqlite-tables-tp19775431p19775431.html Sent from the SQLite mailing list archive at Nabble.com. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
