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,


PHP Database Mailing List (http://www.php.net/)
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
To contact the list administrators, e-mail: [EMAIL PROTECTED]

Reply via email to