Re: [firebird-support] Replication software

2013-08-29 Thread Sudheer Palaparambil
Hello, Pls give a try to symmetricDS, free and open source. Thanks and regards. Sudheer On Mon, Aug 26, 2013 at 10:32 AM, W O sistemas2000profesio...@gmail.comwrote: Copy Tiger program and documentation are very differents. The screenshots are not the same, never CTAdmin.exe

RE: [firebird-support] Classic vs Superserver

2013-08-29 Thread Leyne, Sean
Tim, We're currently running Classic, and I'm looking into the possibility of switching to Superserver for the following reasons: (1) Garbage collection - we sometimes get queries, that normally complete in reasonable time, taking many times as long, and one possible explanation is garbage

[firebird-support] How to create automatically a .SQL file?

2013-08-29 Thread W O
Hello everybody In a Firebird's datatabase I have a large table with thousands of records, is there a simple way for send these records to a text file? My idea is to have a script with the INSERT INTO commands. Something like it: INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(1, 'Alicia',

Re: [firebird-support] Classic vs Superserver

2013-08-29 Thread Alexandre Benson Smith
Em 29/8/2013 12:17, Tim Ward escreveu: But I thought Superserver used threads? And threads can run on separate CPUs? (Processes are an address space thing, not a CPU thing.) There are threads, but in fact they are serialized, perhaps it's just an over simplification, I don't know FB

RE: [firebird-support] Classic vs Superserver

2013-08-29 Thread Leyne, Sean
Alexandre, I will not worry about the shared cache, the file system cache will do almost the same as the shared cacee in SS will do, you will have a small memory overhead because of the separed caches for each connection, even if will set default cache to 1000 you will have 8MB or 16MB of

[firebird-support] Re: How to create automatically a .SQL file?

2013-08-29 Thread chris.waldmann
--- In firebird-support@yahoogroups.com, W O sistemas2000profesional@... wrote: Hello everybody In a Firebird's datatabase I have a large table with thousands of records, is there a simple way for send these records to a text file? My idea is to have a script with the INSERT INTO

Re: [firebird-support] Re: How to create automatically a .SQL file?

2013-08-29 Thread W O
Thank you very much for your answer Christian, I shall try your sugestion. Greetings. Walter. On Thu, Aug 29, 2013 at 2:54 PM, chris.waldmann christian.waldm...@rte-ag.ch wrote: ** --- In firebird-support@yahoogroups.com, W O sistemas2000profesional@... wrote: Hello everybody