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,
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,
>
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
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
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
5 matches
Mail list logo