mysql select some sort of caching

2009-10-20 Thread David Sfiligoi
Hi I am normally an SQLlite person because it just works... but I decided to keep inproving my skills set and do my new project using a MySQL database backend because of the architecture decision I made(horizontal scalable system via message queues). The project is architected around a rabbitmq

Re: mysql select some sort of caching

2009-10-21 Thread David Sfiligoi
On Wed, 21 Oct 2009 00:45:21 -0300, Gabriel Genellina wrote: > > If you want to keep the cursor open, you must commit the (implicit) > current transaction, even if it only contains selects (a rollback would > work too). > Alternatively, lower the transaction isolation level below "repeatable > rea