Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-09 Thread Mike Ro miker...@gmail.com [firebird-support]
On 09/06/14 17:42, Olivier Mascia o...@integral.be [firebird-support] wrote: > gfix -write async test.fdb -user sysdba -password secret It, of course, has a tremendous impact on such tests. Though, everybody should carefully consider wether the risks of data corruption are acceptable (or not

[firebird-support] Re: flamerobin access from client

2014-06-09 Thread bye...@byerly.biz [firebird-support]
Finally getting back to this - I will make this change at the customer sit and see what happens - thanks again.

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-09 Thread Mike Ro miker...@gmail.com [firebird-support]
On 09/06/14 19:11, Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support] wrote: > So the only mystery (for me!) remaining is why the UDF is so much faster > when it is writing 4096 bytes at time with forced writes on? Usually it is faster to let the server do the dirty work, bu

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-09 Thread Olivier Mascia o...@integral.be [firebird-support]
Le 9 juin 2014 à 15:51, Mike Ro miker...@gmail.com [firebird-support] a écrit : > 3. Set the database mode to be asynchronous with: > > gfix -write async test.fdb -user sysdba -password secret It, of course, has a tremendous impact on such tests. Though, everybody should carefully conside

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-09 Thread Frank Schlottmann-Gödde fr...@schlottmann-goedde.de [firebird-support]
On 09.06.2014 15:51, Mike Ro miker...@gmail.com [firebird-support] wrote: > So the only mystery (for me!) remaining is why the UDF is so much faster > when it is writing 4096 bytes at time with forced writes on? Usually it is faster to let the server do the dirty work, but I'm not sure that it i

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-09 Thread Mike Ro miker...@gmail.com [firebird-support]
On 09/06/14 09:25, Olivier Mascia o...@tipgroup.com [firebird-support] wrote: I am seeing 45 seconds for a 13Mb file using C++ / IBPP and 48 seconds using PHP. Exactly the same code, database structure and hardware on Windows inserts a 13Mb BLOB in just 2.4 seconds! That just means the c

Re: [firebird-support] Blob write to Embedded on Linux performance

2014-06-09 Thread Olivier Mascia o...@tipgroup.com [firebird-support]
Le 6 juin 2014 à 15:11, Mike Ro miker...@gmail.com [firebird-support] a écrit : > I am seeing 45 seconds for a 13Mb file using C++ / IBPP and 48 seconds using > PHP. > > Exactly the same code, database structure and hardware on Windows inserts a > 13Mb BLOB in just 2.4 seconds! That just mea