DelphiFAQ Home Search:

InterBase is slow


comments24 comments. Current rating: 5 stars (7 votes). Leave comments and/ or rate it.


I have setup Interbase 6 on an XP Pro computer and it does run however it is extremely slow. What can I do?


  1. if on Windows XP, try turning off system restore
  2. If you IB is runnig on a processor with hyperthreading, search the web for IB_AFFINITY.ZIP.
    At the time of writing, you can find it at
    IB_Affinity is a utility to set InterBase's affinity to a single CPU. Needed on SMP servers for InterBase databases before version 6.5, not needed for Firebird. IBServer has to run as an application for this to work.

Content-type: text/html


You are on page 1 of 2, other pages: [1] 2
2005-12-08, 07:03:36
nsfzor from Finland  
this helped in dos-promt giving command in DOS promt
C:\Program Files\Borland\InterBase\IB_affinity>ib_affinity -A1
Affinity mask set to 1

C:\Program Files\Borland\InterBase\IB_affinity>ib_affinity -q
Current affinity mask: System=3, IBServer=1
2006-01-12, 11:38:35
AndyDm from United States  
Great Job!
It works now on WinXP with Hyperthreading!
2006-05-04, 10:34:52
Delphi Programmer from United States  
Its great !!!!!!! Thank you !!!!

2006-07-19, 02:04:49
anonymous from Philippines  
does this work on interbase 7.5.1? i'm having trouble with my applications developed from delphi 7.
2006-08-13, 22:30:44
anonymous from Lithuania  
For 7.5.1 you must find second service pack. Version works fine with hyperthreading.
2006-10-19, 11:05:48
[hidden] from Mexico  

i have a W2K3 server, with a xeon processor, i install the IB_affinity, now i can't connect my remote users with RDP to my application with the Interbase DataBase

somebody knows what can i do , to connect my remote users by terminal servers

2006-11-22, 01:32:42
anonymous from Vietnam  
I also have W2k3 server, I using InterBase 7.5.1. The data base be come 1 more GB but run Dackup and Restore very slow. The windows show 'finishing ' but the messenger 'Backup Data complete' long time for come out, may be 3 or 4 hour. Everybody knows pls give me advise. How can i do?
2007-02-02, 19:55:40
anonymous from Indonesia  
the ib_affinity really worked to speed up my ibserver. Thanks!
2007-03-10, 09:09:41
anonymous from Thailand  
Good Thanks!!!!!!!!!!!!!!!
2007-03-27, 03:22:10
anonymous from Egypt
2007-07-01, 21:04:21
anonymous from Taiwan  
Thanks a lot ~~
Also thanks to nsfzor from Finland!!
2007-09-18, 09:26:32
anonymous from Mexico  
Somebody get it works on windows vista?
2007-09-18, 11:01:20
anonymous from Mexico  
ok, in Windows Vista the interbase must be run as Application
2008-02-22, 03:45:20
anonymous from New Zealand  
Many thanks for your advice, I installed a dual processor motherboard on my computer and subsequently Interbase 6 became VERY slow. I downloaded Firebird-2.0.3 ( http://www.firebird..ngine_203) and now my databases fly!!
2008-04-29, 17:58:28
newbie from New Zealand  
ib_affinity really works and speeds up interbase 6 and it's great.

However, I have a problem and I hope someone could advise me?

I'm using Delphi 2006 and OS is Windows XP. I configured the processor to run on processor 2 using ib_affinity (ib_affinity -Q -a2). I can't be certain that the access violation error which I'm getting now in module dbkdebuggide100.bpl is related to configuring interbase on run on single processor, but I only started getting this violation error after I started using IB_Affinity.

Any advise will be greatly appreciated.

You are on page 1 of 2, other pages: [1] 2



NEW: Optional: Register   Login
Email address (not necessary):

Rate as
Hide my email when showing my comment.
Please notify me once a day about new comments on this topic.
Please provide a valid email address if you select this option, or post under a registered account.

Show city and country
Show country only
Hide my location
You can mark text as 'quoted' by putting [quote] .. [/quote] around it.
Please type in the code:

Please do not post inappropriate pictures. Inappropriate pictures include pictures of minors and nudity.
The owner of this web site reserves the right to delete such material.

photo Add a picture: