List:General Discussion« Previous MessageNext Message »
From:Dan Nelson Date:October 17 2000 8:45pm
Subject:Re: Mysql isnt keeping up.
View as plain text  
In the last episode (Oct 17), Jeremiah J. Cassidy said:
> If I do the following sequence:
> INSERT
> SELECT
> INSERT
> SELECT
> INSERT
> SELECT
> 
> how do I make sure that the SELECTs are an accurate representation of
> the data that I just INSERTed?
> 
> After the first INSERT, the first few SELECTs don't reflect the fact
> that the INSERT took place.

Chances are your indexes are corrupt and messing up your SLEECTs. As
long as you're not doing INSERT DELAYED, the record should be updated
before the INSERT returns control back to your program.

-- 
	Dan Nelson
	dnelson@stripped
Thread
Mysql isnt keeping up.Jeremiah J. Cassidy17 Oct
  • RE: Mysql isnt keeping up.Jeremiah J. Cassidy17 Oct
    • Re: Mysql isnt keeping up.Gerald L. Clark17 Oct
    • Re: Mysql isnt keeping up.Dan Nelson17 Oct
    • how to install mysql on NTNarayan18 Oct
      • Re: how to install mysql on NTMiguel Angel Sol√≥rzano18 Oct
      • Re: how to install mysql on NTChristopher R. Jones18 Oct
RE: Mysql isnt keeping up.Jeremiah J. Cassidy17 Oct