database, use your PHP or Perl code or whatever you use in order to specify
which table to use.
- Jonathan
-Original Message-
From: Andy [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 26, 2001 12:41 AM
To: [EMAIL PROTECTED]
Subject: Re: [PHP-DB] How to speed up querries in a humangous
Hello,
Andy wrote:
>
> this is my sql statement:
>
>$stmt= "
> SELECT *
> from $geo_T3
> WHERE country_code = '$country' AND province = '$province'
> order by city ASC
>";
You can do two things to speed up the query:
- Never use * for selecting columns in production c
Is this the same question posted about 10 days ago regarding countries and
provinces?
Is the query any faster if you run it at the MySQL console?
Does the query work if you remove the single quotes surrounding $province,
assuming the province filed corresponds to "field3" in your original mes
this is my sql statement:
$stmt= "
SELECT *
from $geo_T3
WHERE country_code = '$country' AND province = '$province'
order by city ASC
";
cheers Andy
"Miles Thompson" <[EMAIL PROTECTED]> schrieb im Newsbeitrag
[EMAIL PROTECTED]">news:[EMAIL PROTECTED]...
>
> To help with
To help with that we'd have to know how your queries are phrased. Please
show us.
Are you having to do a type conversion on the tinyint field?
Miles Thompson
At 02:07 AM 12/26/2001 +0100, Andy wrote:
>Hi there,
>
>I have a huge table with over 2 million entries. It takes to long to make a
>qu