Re: [firebird-support] Periodic database slowdown - troubleshooting steps?

2012-09-23 Thread Thomas Steinmaurer
I have an FB 2.1.5 Classic server running on a Windows 2003 server, with a single hard drive for the operating system, and a 3 disk raid 5 array for the database. We have one database on this machine, which is a dialect 1 database that was started on IB6.0 many years ago, currently at 90GB.

[firebird-support] [Ubuntu] Installed Firebird, how can I remove it to install it again properly?

2012-09-23 Thread bitcointrading
Hey people! I installed Firebird, but not via apt-get because it didn't work, so I installed it by downloading it, extracting, compiling. Now the other developer says we need to remove it and then install it properly from apt-get. I looked around and around, can't figure out how to remove

[firebird-support] Re: Is there a CHARACTERDIFF() function in Firebird?

2012-09-23 Thread red_october2009
I used UDFs for years until FB2x came along. I view UDFs as a stop gap non-standard solution until a built-in standard solution can be implemented. I would much rather dump all my UDFs and use FB functions instead. --- In firebird-support@yahoogroups.com, Andrea Raimondi andrea.raimondi@...

Re: [firebird-support] Re: Is there a CHARACTERDIFF() function in Firebird?

2012-09-23 Thread Doug Chamberlin
On 9/23/12 9:22 PM, red_october2009 wrote: I used UDFs for years until FB2x came along. I view UDFs as a stop gap non-standard solution until a built-in standard solution can be implemented. I would much rather dump all my UDFs and use FB functions instead. Of course, that is one reason for

[firebird-support] Other way of specifying INSERT INTO... RETURNING...

2012-09-23 Thread Reinier Olislagers
Hi list, Firebird 2.5 Linux server. I'm trying to work around a bug in the FreePascal 2.6.0 compiler that thinks all INSERT statements never return data. This bug has been worked on since but 2.6.0 is the last stable version so I'd prefer to be able to support that. I'm trying to fool the