RE: [firebird-support] Firebird performance question

transmission in error, please notify the sender and properly dispose of the information immediately. [Marius Labuschagne] Hi Bill, I don’t have the answer, but will also keep an eye on this question. What I can tell you as that I am running my Client sites on 2.5.3 Superserver, some Clients with 2008

[firebird-support] Create Date of Database Object

Hi, Is it possible to see from the systems tables when a database object was created? For instance I want to try and find out when a specific trigger was created on the database, is this possible? Thanks Regards Marius J. Labuschagne N Dip CDP, B Com (Strategy and IT), IMM

RE: [firebird-support] Optimizing this select Query

SALES.POSTSTATUS = 'Posted' AND SALES.SALE_DATE BETWEEN :vStartDate AND :vEndDate AND SALEITEMS.SKU+0 = :vSKU AND SALES.CASHCREDIT = 'Cash' and see if it uses the Date index. see you ! __,_._,__ [Marius Labuschagne] Hello Alexandre, Thanks for taking the time to have a look. Index

RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

for free in this support list, sorry. Try other Firebird service providers: http://www.firebirdsql.org/en/professional-support/ may be they have free time. Regards, Alexey Kovyazin IBSurgeon [Marius Labuschagne] What you doing in this forum Alexey? As far as I am aware this is a support forum

RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

and verify that the problems was gone. I thin you have to look up in other direction. [Marius Labuschagne] We have sites running Windows 2008 R2 64bits (Xeon Quad Core E31220 @ 3.1 Ghz) , with much smaller databases (2-4GB Range), and on Firebird Super Server 2.5.2, and I can tell you

RE: [firebird-support] Re: Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

17.02.2014 21:36, Marius Labuschagne wrote: Example: Executing the Month-End in our application, exact same database: - On a Win 2008 R2 64-bit Xeon Machine with 8GB RAM: 55 Minutes - On a Win 7 Pro 64-bit I3 machine with 8GB RAM: 9 Minutes Isn't a Win 2008 R2 machine a primary domain

RE: [firebird-support] Very very very slow FB 2.5.2 64bit performance on Windows 2008 R2

they will provide more details who they achieved it. [Marius Labuschagne] Hi Alexey, I suppose we all have our opinions. I do not agree with yours though, as out of the box installs of Firebird, no tweaked configurations for Firebird, performs well on all configurations and OS's I have tried, except on Win

[firebird-support] Recording Update statements and User that executed

Hi, Is it possible to record any UPDATE statement that is executed against a database, from the database level? Something very strange happened to one of my Clients databases, where one field in a table was set to another field in the same table (both double precision fields). I suspect that

RE: [firebird-support] Recording Update statements and User that executed

[Marius Labuschagne] Hi, Is it possible to record any UPDATE statement that is executed against a database, from the database level? Something very strange happened to one of my Clients databases, where one field in a table was set to another field in the same table (both double precision fields

[firebird-support] Recording Error Trapped in Stored Procedure

Hi, I am making using of the WHEN clause to trap any exceptions that are produced during the execution of my stored procedure (non selectable). ... WHEN ANY DO BEGIN INSERT INTO SP_ERRORS (ROWNO, EXCEPT_MESSAGE) VALUES (:vIRN, ); END ... How can I store the value (text) of the

RE: [firebird-support] Recording Error Trapped in Stored Procedure

Hi, I have used SQLSTATE to record the error state. I will then just go find the message for the SQLState on the internet. Regards Marius

[firebird-support] Finding when a Database Object was created

Hello, Is it possible to perform a query against the system tables that will tell me when (Date) a certain trigger or stored procedure was created? Or is there another way to get that information? Regards Marius J. Labuschagne

[firebird-support] lock conflict on no wait transaction - finding the user

Hi, Is there something I can do to find out which user is locking a particular record in a database? If I can use the transaction number to lookup the user, then I may be able to simply ask that user to re-start his machine? The server is running Firebird Superserver 2.1.4 on Windows. I am

RE: [firebird-support] GBAK Restore Crash

Thank you Alexey, I will instruct my Client to execute another backup. I’m making the assumption then that this is not a Firebird issue but rather just the luck of the draw when backing up the database? Regards Marius   Hello Marius, Can anyone advise what I should be trying, or why this is

RE: [firebird-support] Firebird Server Crashing - Please help

-support@yahoogroups.com [mailto:firebird-support@yahoogroups.com] On Behalf Of Marius Labuschagne Sent: 25 August 2011 01:59 PM To: firebird-support@yahoogroups.com Subject: [firebird-support] Firebird Server Crashing - Please help Hi, We are trying to restore a database of one of my

[firebird-support] Firebird Server Crashing - Please help

Hi, We are trying to restore a database of one of my Clients on there new server, but during the restore process it seems that Firebird breaks. The platform is as follows: Windows 7 Professional 64-bit Firebird 2.50.26074 64-bit, downloaded from www.firebirdsql.org 8GB of RAM Firebird.conf is