Re: [firebird-support] Replication software
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 saves the .INI files at the CONFIG folder as the documentation say. CTReplicator.exe has not the option Import configuration as a screenshot of the documentation shows and so. After several hours it was impossible to replicate a database with CopyTiger. We had tried with Windows XP and Windows 7, with administrator rights, with folders outside Program files but ... nothing, it never saves the .INI files neither start the replication proccess. I don't remember now the details with FBReplicator because a coworker was trying that but without success, too. Greetings. Walter. On Sun, Aug 25, 2013 at 9:08 PM, Leyne, Sean s...@broadviewsoftware.com wrote: ** Walter, Someone knows some good program for to do replication of Firebird's databases? I had evaluated CopyTiger and FBReplicator but both have fails. How did they fail? Some details might help understand your needs. Sean [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links [Non-text portions of this message have been removed]
RE: [firebird-support] Classic vs Superserver
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 collection. We understand that Superserver has a background GC thread, so the chances of a two second user operation being randomly delayed by minutes can be reduced or eliminated. (2) Cache size. With frequent operations on a particular table occupying around 1,500 pages the cache size of 150 that we're currently using is believed to limit performance. So some questions: (3) Do these motivations make sense? Yes and no. ;-] Classic does not provide the fastest performance, but it does provide the most consistent multi-connection performance. It is currently (v3 will be changing this) the only engine which truly scales across CPUs. Garbage Collection is performed actively, but if you have good transaction management, the real overhead is not that bad. The biggest cost of Garbage Collection is that it generates disk writes, which will need to go to disk, which is a slow process. A good disk controller cache with protected write-back cache will eliminate that cost. Cache is and isn't a limitation, yes the engine will need to go to the OS for pages not in FB cache. With a reasonable amount of RAM in your server, however, the OS itself will have most 'hot' database pages cached, so you will not actually be going to disk to get the data. Here the faster the media, the lower the cost of the reads will be. Sean
[firebird-support] How to create automatically a .SQL file?
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', 444555); INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(2, 'Beatriz', 654321); So, when I initialize the database in another location I can put all those records into it using the INPUT command of ISQL. Greetings. Walter. [Non-text portions of this message have been removed]
Re: [firebird-support] Classic vs Superserver
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 internals, but the threads does not run in parallel (FB 3.0 will fix that). If you have a multi core server (wich is an obvious thing theses days) you should prefer Classic Server, the only case where I think SuperServer will be a choice is when you have just one connection per database. Perhaps you have automatic sweep disabled (check with gstat -h), if you have sweep disabled the garbage will acumulate, so when a query need to scan the table it will pay the cost to clean it up. I am not saying to use automatic sweep, since it could trigger in the middle of the day generating an unknown slowdown... What I suggest is that you keep automatic sweep disabled and run a manual sweep (gfix -sweep) during off peak hours. 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 cache duplication per connection, not that much... see you !
RE: [firebird-support] Classic vs Superserver
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 cache duplication per connection, not that much... The only problem is that a large number (I would call 1000 a large number) of cache pages adds a significant load on the lock manager (which can be a contention point). A 'small' number for the cache size is recommended (personally, I would say between 75 and 300 pages) and leave the rest for the OS cache purposes. Sean
[firebird-support] Re: How to create automatically a .SQL file?
--- 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 commands. Something like it: INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(1, 'Alicia', 444555); INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(2, 'Beatriz', 654321); So, when I initialize the database in another location I can put all those records into it using the INPUT command of ISQL. Greetings. Walter. [Non-text portions of this message have been removed] Hi Walter I use IBExpert for this, but I don't now if the personal editon has this Export option. You can use also FlameRobin Happy coding Christian
Re: [firebird-support] Re: How to create automatically a .SQL file?
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 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', 444555); INSERT INTO MyTable(MyCol1, MyCol2, MyCol3) VALUES(2, 'Beatriz', 654321); So, when I initialize the database in another location I can put all those records into it using the INPUT command of ISQL. Greetings. Walter. [Non-text portions of this message have been removed] Hi Walter I use IBExpert for this, but I don't now if the personal editon has this Export option. You can use also FlameRobin Happy coding Christian [Non-text portions of this message have been removed] ++ Visit http://www.firebirdsql.org and click the Resources item on the main (top) menu. Try Knowledgebase and FAQ links ! Also search the knowledgebases at http://www.ibphoenix.com ++ Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) * To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com * To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/