InterBase is slow

23 comments. Current rating: (7 votes). Leave comments and/ or rate it.

Question:

Answer:

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 http://source.ibobjects.com/contributed/IB_Affinity.zip.
   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.
   

Comments:

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

2005-12-08, 07:03:36

nsfzor from Finland

Great 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 Thanks

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

Hi 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

moustafaezzat@yahoo.com

2007-07-01, 21:04:21

anonymous from Taiwan

great! 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!!

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

NEW: Optional: Register   Login Email address (not necessary): Rate as Off-topic Very Helpful Helpful Ok article Not useful Very bad	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. Add a picture: