1) what is the timeout for php? The default timeouts are generally pretty low, often 5 seconds or less. 2) What type of indexes do you have on these tables? Indexes speed up query performance vastly. 3) Query performance is generally _much_ more sensitive to how many rows a table has rather than how many columns it has.
On Thu, Oct 2, 2008 at 4:40 AM, bcit6k <[EMAIL PROTECTED]> wrote: > > 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 > _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
