Re: multiple queries in the same "request"

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Gabriel B. wrote:

   You can't send multiple queries in an SQL statement. You can just
split that in two separates queries. It's not really slower by any

I'm not really concerned about performance. i'm *really* concerned
about race conditions.

I have more than 3mi hits per day. the chance that two pairs of
queries will run consecutively is imense.
Then you need to use transactions, which fill your purpose :) I presume you're using MySQL or Postgres, google for START TRANSACTION and COMMIT.

   -- Bruno Ferreira

[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux