I am have a problem with a query which may well have over 200,000 records. I
have building a website using PHP and PHP is timing out after 30secs due the
the size of the call_data table (I think). Is there anyway I can improve the
following query so that it is faster. I think I am using sqlite
Lloyd Thomas wrote:
I am have a problem with a query which may well have over 200,000
records. I have building a website using PHP and PHP is timing out
after 30secs due the the size of the call_data table (I think). Is
there anyway I can improve the following query so that it is faster. I
Hi there,
I am have a problem with a query which may well have over 200,000 records.
I
have building a website using PHP and PHP is timing out after 30secs due
the
the size of the call_data table (I think). Is there anyway I can improve
the
following query so that it is faster. I think I
Hi again,
There are no indexes in may tables. Please find the following schemas for
my
tables. Would it make more sense to convert my datetime columns to
microtime?. What other recommendations would you make for these tables?
CREATE TABLE users (
user_id INTEGER PRIMARY KEY,
extn_no
Lloyd Thomas wrote:
There are no indexes in may tables. Please find the following schemas
for my tables. Would it make more sense to convert my datetime
columns to microtime?. What other recommendations would you make for
these tables? CREATE TABLE users (
user_id INTEGER PRIMARY KEY,