... Even if 1.5.5 have no index related fixes (i don't remember) it have a few other important enough fixes. There is ZERO reasons to use any of 1.5.x version...
... Are your "Caps Lock" key is locked forever ? Don't use capital letter - it means a scream and very annoying for readers. ... You forget "cdecl" in function...
My current project is developing rapidly so I wondered how other developers handle generating the script to do each upgrade. I can compare the ddl using dev...
... I make upgrade scripts by hand and use DB comparsion tools only to check that upgraded database is (more or less) equival to model one, created from...
... I always have two DB's on my dev environment. Master and Target. I develop all I want on Master until it's time to deploy a revision. I do a compare...
Thanks Vlad I agree about 1.5.5 I will do that anyway- I was just curious to know what was included, index wise. As I said before 2.1 presents problems that...
Hello all, i was just playing with gen_uuid() in firebird 2.1.2 i did the following add a field to a existing table with a little more then 2 mio record guid16...
Is it possible to have a trigger fire for an insert/update/delete only after all changes to the table have been committed? I'm not up-to-date on 2.0 - 2.5 so I...
Rick Debay
rdebay@...
May 1, 2009 4:16 pm
101885
... No, because strlen() (at least in fbudf) count bytes only till zero character. You must stop using UDF and use built-in functions such as OCTET_LENGTH. SY,...
... found it , if i use the new char_length built in function instead of the supplied udf strlen then the result is as expected ... -- Mit freundlichen...
... No ... You could use ON TRANSACTION COMMIT trigger with, probably, help of RDB$SET_CONTEXT\RDB$GET_CONTEXT functions. But it fire at transaction commit...
Hello I'm starting with firebird : System: VB6, firebird, winxp I have the following doubts: 1. How can I generate a transaction log or log the transactions. ...
Hi all, I m looking for the next stable version of firebird after 2.0, i came to know that 2.1.1 had some bugs which got fixed in 2.1.2. But i m not sure if...
... yes it is. it is the most updated version (can I say this way in english? ;) The most recent version from FB2.0.x is 2.0.5. But FB2.1.x series is the next...
Hi, ... First you're talking here about 2 main FB versions, 2.0 and 2.1 The last production version for 2.0 series is 2.0.5 (for those who still use 2.0) The...
Hi there, I need a tool to see/inspect the actual SQL command and values sent to my (embedded) firebird server from a C# windows application. I'm trying to fix...
Hi All i have one database develop it over 4 years old long ... from two years ago to now i frequntly have index page error in validation only for one table...
Hi, ... I don't know about your problem but I do know you must fix your buffers setting. Using 32Mb for each connection is not of any value to your app and may...
... If a running Classic process crashes due to an out-of-memory error, it is quite possible to corrupt any data that was in the process of being written. A...
... Hi heLen yes after every Backup / restore my problem solved but from two day to 4 day i see it again ! then this is not good what i do to DON'T SEE it...
... Change the size of the page cache. Read again the response from Anderson Farias and do what he describes. In fact, I think 50 pages is too little if you...
@helen This same my problem. What the ideal setting if: Ram 2Gb User client 40 and online db 20 hour/day Have 120 tables Because every week I m always sweep...
allies_xposs@...
May 4, 2009 5:06 am
101902
... 50% ! [PM] If your OS is win2003 32bit then you can't acces all 6 Gb RAM. Regards, Paul....
... Why would a "random check" help you to decide this is not a memory usage problem? You keep getting index corruption at 5-day intervals. That could be one...
Hello, I know how to upgrade/reinstall Firebird on Windows, but on Linux, I'd better ask before screwing up the production server. ;-) I'm running Firebird...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
