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 that
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
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 code. You
the
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
Hi there,
I have a huge table with over 2 million entries. It takes to long to make a
querry. No I am thinking about the datatypes. Maybe there is a better way. I
have already indexed the search fields ( which made the table 75 MB big!!!)
My table looks like that:
field1 : varchar100
field2 :
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
