Re: How to speed up querries in a humangous db?
| From: | Andy | Date: | Wed, 26 Dec 2001 08:41:26 +0000 |
| Subject: | Re: How to speed up querries in a humangous db? | ||
| References: | 1 2 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15216@lists.php.net to get a copy of this message | ||
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" <milesthompson@ns.sympatico.ca> schrieb im Newsbeitrag
news:5.0.2.1.0.20011225222605.01cc2870@pop1.ns.sympatico.ca...
>
> 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
> >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 : char2
> >field3 : tinyint2
> >
> >I have an index on field 2 and 3
> >
> >The SQL Querry is searching for: field 2 AND field 3
> >
> >Does anybody have an Idea how to spead this up?
> >
> >Thanx in advance,
> >
> >Andy
> >
> >
> >
> >--
> >PHP Database Mailing List (http://www.php.net/)
> >To unsubscribe, e-mail: php-db-unsubscribe@lists.php.net
> >For additional commands, e-mail: php-db-help@lists.php.net
> >To contact the list administrators, e-mail: php-list-admin@lists.php.net
>