How to speed up querries in a humangous db?
| From: | Andy | Date: | Wed, 26 Dec 2001 01:07:02 +0000 |
| Subject: | How to speed up querries in a humangous db? | ||
| Groups: | php.db | ||
| Request: | Send a blank email to php-db+get-15213@lists.php.net to get a copy of this message | ||
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