""Toby Hart Dyke"" <t...@hartdyke.com> wrote in message 
> It sounds as though you don't have an index on the right field. 8 million
> records should be no problem if you have the right indexes applied, and
> you're not trying to do anything too complicated.
>  Toby

I doubt that the State field is a primary index, or that it would be used as 
one, which means that it could be a secondary one.  If it is - that would be 
a pretty long record itself and could be the problem therein.  With 
virtually all the records tied to one secondary key it is mostly a worthless 
secondary index.  I'd try removing it and seeing what happens. 

PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Reply via email to