i'm using myisam. Is there any tip i should know before to migrate this
table to innodb ?
Thanks !
----- Original Message -----
From: "Gleb Paharenko" <[EMAIL PROTECTED]>
To: <mysql@lists.mysql.com>
Sent: Tuesday, November 29, 2005 12:35 PM
Subject: Re: locking issues
Hello.
What table engine do you use for your tables? InnoDB usually
is the best choice if you have lots of concurrent updates and inserts.
"PaginaDeSpud" <[EMAIL PROTECTED]> wrote:
I'm getting locking issues due to tables very often updated/insert.
It's splitted into two tables, one has the more updated data and the
another
has the more static data. I'm using queries with JOIN, would it be better
for performance to use two queries instead of using JOIN?
Thanks.
Ivan L.
--
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
__ ___ ___ ____ __
/ |/ /_ __/ __/ __ \/ / Gleb Paharenko
/ /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED]
/_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET
<___/ www.mysql.com
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:
http://lists.mysql.com/[EMAIL PROTECTED]
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
