Re: [firebird-support] port requirements for Firebird Services API - IBAnalyst

2014-05-30 Thread Office Manager office...@href.com [firebird-support]
Follow-up on this issue... The problem was that an old copy of gdb32.dll was sitting in C:\Windows\SysWOW64. That was loaded before IBAnalyst tried to use fbclient.dll, and it was not suitable. The solution was to copying the recent 32-bit fbclient.dll to gds32.dll in the same folder as

[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)

[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

[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 select

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 within a

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

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

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

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] firebird-support@yahoogroups.com 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

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”

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