Re: for loop problem?
| From: | jimmy elab | Date: | Wed, 14 Nov 2001 02:36:10 +0000 |
| Subject: | Re: for loop problem? | ||
| References: | 1 2 | Groups: | php.general |
| Request: | Send a blank email to php-general+get-74530@lists.php.net to get a copy of this message | ||
Tyler Longren wrote:
>
> Here's something interesting though. There's an id field that's set to
> AUTO_INCREMENT.
Yep, and that's one thing I've been looking at. See, I find it strange
that you need an KEY idpass (id, passcode(245)) when the ID is
quaranteed to be unique in itself.
Funny... Would not explain why you get more, I'd rather expect you to
get fewer entries.
Anyway. Try this: Drop the passcode VARCHAR and make it fixed CHAR(10).
It seems like MySQL can't keep up with the speed of your inserts, and
varchar is obnoxiously slow.