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: [EMAIL PROTECTED]
>For additional commands, e-mail: [EMAIL PROTECTED]
>To contact the list administrators, e-mail: [EMAIL PROTECTED]


-- 
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