Re: [sqlite] Failure on big sqlite tables

2008-10-02 Thread Jeffrey Becker
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 h

[sqlite] Failure on big sqlite tables

2008-10-02 Thread bcit6k
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 100 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 p