4 messages in com.mysql.lists.mysqlRe: locking issues
FromSent OnAttachments
PaginaDeSpud28 Nov 2005 18:29 
Gleb Paharenko29 Nov 2005 03:35 
PaginaDeSpud29 Nov 2005 22:33 
Gleb Paharenko30 Nov 2005 08:29 
Subject:Re: locking issues
From:Gleb Paharenko (gleb@ensita.net)
Date:11/29/2005 03:35:35 AM
List:com.mysql.lists.mysql

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" <webm@paginadespud.com> 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.