Re: How to speed up querries in a humangous db?
| From: | Miles Thompson | Date: | Wed, 26 Dec 2001 02:27:46 +0000 |
| Subject: | Re: How to speed up querries in a humangous db? | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-15214@lists.php.net to get a copy of this message | ||
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