[ciapug] Mysql

[David Champion]

Dave J. Hala Jr. wrote:
> I'm running  mysql 3.23.58.  I've run into an issue inserting records
> into a table. The query criterion tells me there are 1281 records. When
> I do the insert mysql only only inserts 591 records.
> 
> Here's the insert query:
> 
> INSERT INTO notify_temp SELECT * FROM lhpl_side WHERE SNP='0';
> 
> Anyone got any ideas as to why it skips/throws out 690 records?
> 
> 
> 
> :) Dave

So you mean if you say "SELECT count(*) FROM lhpl_side WHERE SNP='0'" it 
returns 1281?

You might want to look into upgrading your mysql version. 3.23.58 was 
released on 9/11/2003. That's ancient.

Going up to 4.1.x, or even 5.x would get you some nice performance 
improvments, as well as several nice features, like sub selects...

-dc