Re: [GENERAL] DBMirror.pl performance change

2006-01-23 Thread Peter Wilson
Achilleus Mantzios wrote: Peter, It is much more convinient for you to make a test, (just change the last function in DBmirror.pl), than for me (grab whitebeam, compile for FreeBSD, etc...) Of course you would need to use the original .conf format than the one you are using now. It would be int

Re: [GENERAL] DBMirror.pl performance change

2006-01-23 Thread Achilleus Mantzios
Peter, It is much more convinient for you to make a test, (just change the last function in DBmirror.pl), than for me (grab whitebeam, compile for FreeBSD, etc...) Of course you would need to use the original .conf format than the one you are using now. It would be interesting to see some number

Re: [GENERAL] DBMirror.pl performance change

2006-01-23 Thread Peter Wilson
The Whitebeam implementation of DBMirror.pl : http://www.whitebeam.org/library/guide/TechNotes/replicate.rhtm is a complete re-write in 'C' which avoids a lot of the text processing, and what text processing is required is done using a state machine rather than repeated regular expressio

[GENERAL] DBMirror.pl performance change

2006-01-23 Thread Achilleus Mantzios
I discovered a problem in DBMirror.pl, performance wise. pending.c stores data in a way very similar to the PgSQL input "\" escaped format. When the field is of type bytea, and the source of data is binary, then this produces 2 additional backslashes for every unprintable char. The performance