[firebird-support] Optimizing Firebird for SSD

2011-12-16 Thread Doychin
hi guys, I'm having this setup here: linux 64 bit server with RAID 5 for database storage. My database is stored on raw device. Right now I'm using FW=ON for this setup. any ideas how to optimize performance for this configuration? The problem is with write operations. They take to much time

Re: [firebird-support] Optimizing Firebird for SSD

2011-12-16 Thread Alexey Kovyazin
Hello, The problem is with write operations. They take to much time and this is OLTP database so write should be very fast. Can you please be more specific in defining the problem? How many records you are inserting or updating per second, how many users do inserts/updates, how