Category: Technical Articles

Technical articles, How-tos, guides, etc.

Firebird slow? Well, maybe it is Windows fault.

One comment

So, you just moved to that new cool server, with lots of RAM, Windows and Firebird 64bits, but suddenly you found that Firebird performance gets worse and worse. When you check TaskMan, you see that 99% of the RAM is being used (and so, swap is going on). If you close Firebird process, RAM usage seems to be back to normal. Weird, uh?

First, you may think this is the common problem of Classic/SuperClassic with too many connections and crazy buffers value… but, you checked all the settings, and everything is ok.

If  this happening to you, take a look again in TaskMan (or Process Explorer), and check how much memory the OS Cache is consuming. If you find something abnormal, like if it is consuming almost all of your physical RAM, you should take a look at this: http://support.microsoft.com/kb/976618/en-us

Firebird usage with SchemaSpy – Java based Graphical Database Schema Metadata Browser

Leave a comment

On devshed firebird forum someone asked if anyone used SchemaSpy with firebird , and later he got it working , here is the command line option (after installing jaybird.jar)
1) Download the ZIP file for jaybird
2) unzip it
3) Copy the file jaybird-full-2.1.6.jar into a convenient directory
4) specify the full path to the .jar file when starting schema spy

java -jar /home/java/schemaSpy_5.0.0.jar -t firebird -db /var/lib/firebird/2.1/data/employee.fdb -s schema -u SYSDBA -p ******* -o /home/firebird/ -port 3050 -host localhost -dp /home/user/jaybird-full-2.1.6.jar

ps:that is a single line

Tip: Using isql-fb / isql with readline in Debian/Ubuntu instead of libedit

Leave a comment

Seems that readline does have utf-8 support and can be used for inserting/selecting accented chars
Check if libedit is used instead of readline

ldd /usr/bin/isql-fb | grep libedit
libedit.so.2 => /usr/lib/libedit.so.2 (0x00007f3dcbd7b000)

export LD_PRELOAD=/lib/libreadline.so.6

check if is preloaded

ldd /usr/bin/isql-fb | grep readline
/lib/libreadline.so.6 (0x00007fc661d22000)

Then use isql-fb as usual

SQL> select * from employee where first_name = ‘ő’

Good news everyone Firebird #Perl extension works with Strawberry

2 comments

We tested Firebird perl extension and now it works with Strawberry perl (almost all the test do pass when installing the extension ) here are the steps described:

also the movie (ogv) (right click on link and save as)

1 … 22 23 24 25 26 … 78