Re: RES: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Josh Hartmann jhartm...@computekdental.com [firebird-support]
We recently had to deal with this issue. Going from 2003 32bit to 08 64bit. The problem is the way FB utilizes system memory when using an older version on a 64bit system. We upgraded to 2.5.2 64bit and it gave us more options for tweaking the usage of system memory VS FB cache. It also fixed FB's

RES: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread 'Fabiano - Desenvolvimento SCI' fabi...@sci10.com.br [firebird-support]
Maybe you dont have a HDD cached controller. Run a program like Crystal Disk Mark in the old computer and in the new computer. If the performance of new computer is terrible you must change your physical hard disk controller. I had this problem with a Dell server that is a “internet server” (w

Re: [firebird-support] Update only changed tuple/ execute if-statement via "execute statement"?

2014-05-30 Thread Ann Harrison aharri...@ibphoenix.com [firebird-support]
On Sat, May 24, 2014 at 8:51 AM, eric wulfhekel eric.wulfhe...@gmail.com [firebird-support] wrote: > > I want to create a update trigger which sets the current date to a field > "modified" if values has changed. I have a lot of tables with a lot of > columns so i want to work with system table f

RE: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
Will do.Thank you.-Halim To: firebird-support@yahoogroups.com From: firebird-support@yahoogroups.com Date: Fri, 30 May 2014 14:31:07 +0400 Subject: Re: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance H

Re: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Alexey Kovyazin a...@ib-aid.com [firebird-support]
Halim, Ok, thank you. 1.5 is really old, upgrade asap. Regards, Alexey Kovyazin Hi Alexey, Here is where I read it. Page 7. PPT Presentation during FDD 2012, Brazil. http://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems# Keep in mind, we are still using 1.5 FB. Thank you

RE: [firebird-support] Firebird 1.5 on 64bit OS. Newer Hardware but bad performance

2014-05-30 Thread Halim Boumedjirek halim1...@hotmail.com [firebird-support]
Hi Alexey,Here is where I read it. Page 7. PPT Presentation during FDD 2012, Brazil.http://www.slideshare.net/ibsurgeon/resolving-firebird-performance-problems#Keep in mind, we are still using 1.5 FB.Thank you,-Halim To: firebird-support@yahoogroups.com From: firebird-support@yahoogroups.com Dat

RE: [firebird-support] Update only changed tuple/ execute if-statement via "execute statement"?

2014-05-30 Thread Svein Erling Tysvær svein.erling.tysv...@kreftregisteret.no [firebird-support]
>Hello, >I would be very happy if anybody could help me. I want to create a update >trigger which sets the current date to a field "modified" >if values has changed. I have a lot of tables with a lot of columns so i want >to work with system table for that task. I build the >if-statement withi

[firebird-support] Update only changed tuple/ execute if-statement via "execute statement"?

2014-05-30 Thread eric wulfhekel eric.wulfhe...@gmail.com [firebird-support]
Hello, I would be very happy if anybody could help me. I want to create a update trigger which sets the current date to a field "modified" if values has changed. I have a lot of tables with a lot of columns so i want to work with system table for that task. I build the if-statement within a selec

[firebird-support] Firebird 2.5 built on AIX 6.1 - core dump

2014-05-30 Thread vvm...@gmail.com [firebird-support]
Hi All, I'm trying to built FB from the source code v. 2.5.2.26540-0 on AIX 6.1 (PPC). I've made some minor changes in the build script to let it create ./configure script, also a couple of source code files slightly changed (mostly to avoid conflicts). But now I'm facing a problem - attempt t

[firebird-support] How to convert big FIREBIRD DB to one charset (win1251) to UTF8 ?

2014-05-30 Thread loris.lu...@gmail.com [firebird-support]
I need your help and/or suggestions to solve a (maybe uncommon) task. I searched a lot on the web and I had some success using a tool called fbclone but this is definitely not a solution (due to extreme slowness of the conversion, many days, something must be wrong with this software) I