On 08/31/11 12:25, Fulvio Senore wrote: > > I must admit that I was executing each query in its own transaction. > Since I was only executing SELECT statements I was thinking that there > was no problem in working this way. I never had performance problems > with Windows and Linux in virtual machines, so I did non think that this > might be a problem. >
That's due to caching effects of VM. > I have tried executing all the queries in a single transaction and now > opening the catalog is lightning fast! It looks like opening and closing > a transaction requires writing to the database, even if the transaction > only executes SELECT statements. The fact that transaction is started/ended must be stored in database. The only exception from this rule is read-only database. > Lesson learned. > > Thank you for solving my problem. > > I am still wondering why performance was so bad with ext4 only, but this > is not a real problem any more, just a matter of curiosity. > A bit offtopic - can you provide a link to take a look at that application? ------------------------------------------------------------------------------ Special Offer -- Download ArcSight Logger for FREE! Finally, a world-class log management solution at an even better price-free! And you'll get a free "Love Thy Logs" t-shirt when you download Logger. Secure your free ArcSight Logger TODAY! http://p.sf.net/sfu/arcsisghtdev2dev Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel
