Go Back   TechArena Community > Technical Support > Computer Help > Windows XP > Windows x64 Edition
Become a Member!
Forgot your username/password?
Tags Active Topics RSS Search Mark Forums Read

Sponsored Links



Firebird performance on Windows Server 2008 R2 Foundation PL

Windows x64 Edition


Reply
 
Thread Tools Search this Thread
  #1  
Old 15-07-2010
Member
 
Join Date: Sep 2004
Posts: 58
Firebird performance on Windows Server 2008 R2 Foundation PL

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??

Reply With Quote
  #2  
Old 15-07-2010
Member
 
Join Date: Sep 2004
Posts: 142
Re: Firebird performance on Windows Server 2008 R2 Foundation PL

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.
Reply With Quote
  #3  
Old 15-07-2010
Member
 
Join Date: Sep 2004
Posts: 58
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.
Reply With Quote
  #4  
Old 18-10-2010
Member
 
Join Date: Oct 2010
Posts: 1
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!
Reply With Quote
  #5  
Old 19-10-2010
Member
 
Join Date: Dec 2007
Posts: 2,273
Re: Firebird performance on Windows Server 2008 R2 Foundation PL

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.
Reply With Quote
Reply

  TechArena Community > Technical Support > Computer Help > Windows XP > Windows x64 Edition
Tags: , , , ,



Thread Tools Search this Thread
Search this Thread:

Advanced Search


Similar Threads for: "Firebird performance on Windows Server 2008 R2 Foundation PL"
Thread Thread Starter Forum Replies Last Post
How to increase the performance of Windows Server 2008 Asheshs Windows Server Help 5 07-06-2013 10:04 AM
Team foundation server 2008 installation problem Kwee Software Development 3 13-07-2009 12:25 PM
Team foundation server 2008 vs source safe Animorc Operating Systems 3 06-07-2009 11:11 AM
What is Windows server 2008 Foundation? Aramax Operating Systems 3 01-04-2009 10:54 PM
Windows 2008 Server Performance Counters missing John Meng Windows Server Help 7 15-10-2008 10:52 AM


All times are GMT +5.5. The time now is 02:37 PM.