Re: [firebird-support] Best Firebird Platform for our Environment

2013-04-02 Thread Alexey Kovyazin
Hello, You need to install 64Gb RAM. If you effective drivers for HDD, OS is not very important. Regards, Alexey Kovyazin IBSurgeon We are trying to determine the best platform for Firebird SQL 2.5.2. Our firebird databases are 40-60gb in size and are being accessed by dbase plus 2.6.2

[firebird-support] Re: Best Firebird Platform for our Environment

2013-04-02 Thread ssilouky
Thanks for the information. In regards to the Windows 2003 Server running RDP, it is running Firebird Superserver 2.1.3 32-bit. What I have noticed is it only uses 1 CPU and it is running at 60-100% utilization. In regards to the dbase Plus programs, there are some dbase files used in

[firebird-support] Re: Best Firebird Platform for our Environment

2013-04-02 Thread ssilouky
How do you determine the amount of RAM needed? Is there a benefit from more than 64gb of RAM? --- In firebird-support@yahoogroups.com, ssilouky bill.simpson@... wrote: We are trying to determine the best platform for Firebird SQL 2.5.2. Our firebird databases are 40-60gb in size and are

[firebird-support] gbak backup slow

2013-04-02 Thread madebymay
Hello. my linux server run a firebird 1.5 version. daily I backup my BD. (name.gdb 3.76 Gb). few weeks ago, i noticed that the gbak process are getting slow and when it is running the aplication that conect the DB is slow. I restarting the firebird service, i work norlmally few days, and

Re: [firebird-support] gbak backup slow

2013-04-02 Thread Thomas Steinmaurer
Hello. my linux server run a firebird 1.5 version. daily I backup my BD. (name.gdb 3.76 Gb). few weeks ago, i noticed that the gbak process are getting slow and when it is running the aplication that conect the DB is slow. I restarting the firebird service, i work norlmally few days,

RE: [firebird-support] gbak backup slow

2013-04-02 Thread Slavomir Skopalik
Hi, similar result is produced if there is long running transaction thats block removing garbage. Try to check open connection to FB server. To confirm this, just kill TCP connection and run gbak twice. First time it will be run long time, second run will be short. Best regards Slavek Ing.

[firebird-support] Re: gbak backup slow

2013-04-02 Thread madebymay
thank for you response I sincerely apreciate it. the command is: /opt/firebird/gbak -b -g -user usuario -password xxx /name.gdb /backup/name.gdk i have the -g option. backups is in dbsever thanks again. --- In firebird-support@yahoogroups.com, Thomas Steinmaurer ts@... wrote: Hello. my

[firebird-support] Re: FireBird 2.5 How can i create 1 byte (0-255) column?

2013-04-02 Thread wan30032
--- In firebird-support@yahoogroups.com, Mark Rotteveel mark@... wrote: On 31-3-2013 17:23, wan30032 wrote: hello,now i used type is smallint. but there are more than 4,000,000,000 records. so i want to change with like ms sql tinyint. For binary data you can use (VAR)CHAR with