|
SQL Maestro Group announces the release of AnySQL Maestro 10.7, a powerful tool to manage any database engine accessible via ODBC driver or OLE DB provider (Access, SQL Server, Firebird, Oracle, MySQL, PostgreSQL, etc).
This version features database profile management extensions, updated Script Runner, improved Data Analysis and Data Import tools, and some other useful things. AnySQL Maestro 10.7 has been successfully tested with Firebird ODBC drivers 1.xy and 2.0 RC1 and all the latest Firebird server versions up to 2.1.3 and 2.5 RC 2. |
(No Ratings Yet)
Loading...Avoid using rand() in where clauses
I was working today, building a procedure to populate some tables and do some data updates and deletes, for speed testing for one of my FDD sessions.
I decided to use the built-in rand() function of Firebird 2.x in the where clause of updates and deletes, but found out that the execution time was tooking too long to complete. Looking at statistics, it showed weird numbers for Indexed Reads, like, the updates of 5 records generating 80.000 indexed reads in the Primary Key index.
After some debugging, I just found out that rand() was the guilt! I moved it outside the update/delete statement, storing the result in a variable, and using the variable in the where clause. It worked million times faster!
So, moral of history: Don’t use rand() in the where clause of updates and deletes statements. And yep, I know this is quite unusual use 😉
(3 votes, average: 3.67 out of 5)Loading...Firebird 2.0.6 released
The Firebird project is pleased to announce the release of Firebird 2.0.6. This maintenance release fixes many registered bugs and also offers a few improvements.
Release notes:
http://www.firebirdsql.org/rlsnotesh/rlsnotes20.html
Download kits:
http://www.firebirdsql.org/index.php?op=files&id=engine_206
Dmitry
(4 votes, average: 5.00 out of 5)Loading...IDEMA – Are you ready?
SAN JOSE, Calif., June 29, 2010 /PRNewswire via COMTEX/ — IDEMA (The International Disk Drive Equipment and Materials Association) today announced the launch of the “Are You Ready?” campaign, an effort to raise awareness in the computer industry about the advances and advantages of long data sectors. IDEMA is the data-storage industry’s trade association dedicated to driving technology standards that support the advancement of data storage. The campaign focuses on helping the computer industry prepare for the transition of hard disk drive (HDD) processing from the historical sector lengths of 512 to 520 byte increments, to increments of 4,096 bytes per sector using a technology referred to as Advanced Format. IDEMA is joined by major hard disk drive manufacturers in the launch and support of the “Are You Ready?” effort.
Read full history here.
(No Ratings Yet)Loading...New Flamerobin snapshots revision 1917
Michael posted new Flamerobin snapshots and announced on the devel list
I have posted new FlameRobin snapshots, SVN revision 1917, for Windows
32 and 64 bit, both installers and ZIP files.
(3 votes, average: 5.00 out of 5)Loading...ANN: dbExpress Driver for Firebird version 26 released
Hi,
dbExpress Driver for Firebird version 26 has released. Here are the
fix:
4.1.2007.26 / 4.1.2009.26 / 4.1.2010.26 Release on 23 Jun 2010
1. Fixed retrieve SQL View names if TSQLConnection.TableScope include tsView when invoke TSQLConnection.GetTableNames
—
Best Regards,
Chau, Chee-Yang
(2 votes, average: 3.00 out of 5)Loading...New Firebird tech articles
Morning all,
I’ve uploaded a couple of new documents to the document area. Unfortunately, due to a few problems with VPN timing out over the weekend, I’ve not been able to get the front page updated. I will do soon and the links will be visible.
How the cache works in Firebird:
pdf: http://www.firebirdsql.org/pdfmanual/Firebird-cache.pdf
html: http://www.firebirdsql.org/manual/fbcache.html
That is based on information Ann supplied here on the list a while back. She has permitted me to document it and make a manual out of it.
Firebird Internals:
pdf: http://www.firebirdsql.org/pdfmanual/Firebird-Internals.pdf
html: Not uploaded yet – VPN problems.
A work in progress and as yet fairly incomplete. It will be improved as and when I can. Comments & corrections gratefully received!
Enjoy.
Cheers,
Norman.
(4 votes, average: 5.00 out of 5)Loading...ANN: dbExpress Driver for Firebird version 25 released
Hi,
dbExpress Driver for Firebird version 24 has released. Here are the
fix:
4.1.2007.25 / 4.1.2009.25 / 4.1.2010.25 Release on 16 Jun 2010
1. Add data type coercion for bytes array to CHAR and VARCHAR
column
—
Best Regards,
Chau, Chee-Yang
(2 votes, average: 3.00 out of 5)Loading...Stored Procedures contest winners!
Dear All,
Stored procedures contest is over!
We had 12 submissions for the contest and have chosen 3 winners.
Winners are:
- Set of mathematical operations implemented in pure Firebird SQL,
by pizmon (muirsheendur…@gmail.com)
Download www.mindthebird.com/MathematicOperation.pdf - XML File creation using Firebird in stored procedures, by Fernando
Medeiros
Download www.mindthebird.com/ToCreateXML.pdf - SP_ESCAPE and SP_UNESCAPE stored procedures: generate text with
line feeds, carriage returns, quotes and tabs in Firebird sql scripts,
by Fabiano Bonin.
Download www.mindthebird.com/SP_ESCAPE.pdf
Each winner can choose one of the following licenses from MindTheBird sponsors:
(6 votes, average: 4.33 out of 5)Loading...Firebird 2.5 RC3 to be released soon
Some fixes for known problems will be commited next week. After that it will be submitted to QA tests, so probably we will have RC3 released at end of June.
(21 votes, average: 4.57 out of 5)Loading...