[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] Copy a database to a blank one

2011-12-16 Thread Milan Babuskov
Sergio H. Gonzalez wrote: Hello! I'm using FB2.5. Is there any command line to copy a database to a blank one? I mean, I need to create an empty copy of a given database, but I'd like to do it using a command in a bath file... I hope I'm clear! I'v been googling but had no luck!. -sergio

[firebird-support] How to drop a user only if it does exist.

2011-12-16 Thread Ichiro Kobayashi
Dear All, I'd like to ask : How to drop a user only if it does exist ? TIA, Ichiro Kobayashi PS : I'm using FB 2.5

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

Re: [firebird-support] Firebird Embedded Multiple Connection Single File

2011-12-16 Thread Ann Harrison
On Fri, Dec 16, 2011 at 12:57 PM, Jean jeando20032...@yahoo.com wrote: My application acts as a work group, where it can be installed in 10 desktops.  In one of the desktop, a shared directory is created to keep the database file.  Each user can access that directory by mapping it as a