Firebird performance on Windows Server 2008 R2 Foundation PL

**Hilfiger** · 15-07-2010

I am using FireBird 2.1.3 (x64) on Windows 2008 R2 Foundation PL (x64) with default configuration. I have 32 bit application which connects to firebird via TCP connection using 32-bit fbclient.dll. My problem is that the application stores several records on every minute in database, this task is taking about 5 to 10 seconds which is too slow. Has anyone faced such kind of connection issue??? or has any idea about it??

**Judy B** · 15-07-2010

I am not sure but it seems as if there's something wrong with Firebird, a better idea will be contacting Firebird. Just address them your issue along with the solution that you might have tried and check out if they are of any help.

**Hilfiger** · 15-07-2010

I don't think there might be anything wrong with Firebird, i have used it on Windows Server 2003 and 2003 R2 and i never has any issue as such. My application used to take just 1 seconds for storing records in database. As far as i can guess Windows 2008 R2 Foundation PL (x64) is having poor storage subsystem.

**turcoags** · 18-10-2010

Hi, I have a similar problem with Windows Server 2008 and firebird 2.5 (both 64 bits tecnology), my hardware features are:
INTEL XEON PROCESSOR E5504, 12 GB RAM (MEMORY: HP
2GB UDIMM (1X2GB) 2RX8 PC3-10600E-9 KIT); NETWORK
CONTROLLER: EMBEDDED HP NC107I PCI EXPRESS
GIGABIT SERVER ADAPTER; STORAGE CONTROLLER: HP
SMART ARRAY B110I SATA RAID CONTROLLER (RAID
0,1,10); HARD DRIVE: TWO (2) HP 250GB SATA 7.2K NHP 3.5"
MDL HDD.

WHEN I DO INSERTS IT TAKES A LOT OF TIME, BUT COMMANDS SELECT, UPDATE AND DELETE ARE OK!!!
CAN SOMBODY HELP ME!

I Want To Add The Aplication Run Very Fast On Windows Xp With All Versions Of Firebird, But I Test In Windows Server 2008 With Firebird 2.1.3 And Firebird 2.5 And The Result It´s A Performance Too Slow!

**EINSTEIN_007** · 19-10-2010

Hi turcoags,

Can you tell us that the slow machine have System Restore on for that drive? Either turn that off or use a different extension than .GDB. Do you use auto commit mode ? If yes, then try to wrap the 5000 records insertion into single transaction. That will seriously raise performance.