4 messages in com.mysql.lists.mysqllocking 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:locking issues
From:PaginaDeSpud (webm@paginadespud.com)
Date:11/28/2005 06:29:41 PM
List:com.mysql.lists.mysql

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.