DelphiFAQ Home Search:

InterBase is slow

 

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

Question:

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

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.


Content-type: text/html

Comments:

You are on page 2 of 2, other pages: 1 [2]
2008-04-29, 17:58:28
newbie from New Zealand  
rating
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.

Thanks
2008-07-15, 11:38:49
anonymous from Brazil  
thank you so much!

helped a lot!
2008-12-16, 16:59:44
anonymous from Sweden  
Perfect!!!! IB6 on XP up and running...
2009-02-19, 09:39:20
chinawholesale from China  
onThesource.com is like her name 'Provide a smooth channel to make everyone on the way to source what you need at less expense'. onThesource.com committees herself to help more and more middle sized wholesalers or retailers to expand their domestic and eBay business at fewer complexity and high efficiency. Currently, you can retail mobile phones, digital MP4 players, memory cards, Bluetooth devices and other electronics widgets from China directly via onThesource.com.

No Minimum Order. Every product can be ordered from one unit or set. Of course, you will be obtained more profits from wholesale break prices once.
Reliable Product Quality. All products will be tested strictly again and again before dispatching out, no matter when they are in factories or in our warehouse.
Lower Prices. All products are from local or nearby factories that will help us to reduce expense and feedback more profits to our customers.
Secure Payments. You can choose PayPal which is well-known for its security and instant rate worldwide. Moreover, you can pay via Western Union, Money Gram or Bank Wire Transfer if you do not have PayPal account.
Fast and Safe Delivery. We will send products out by express ways or Air Mail. Doing business with onThesource.com is very smooth beyond that you can imagine.
Long Term Warranty. Every product will enjoy one year warranty period here.
Professional and Customer-oriented Pre-sales and After-sales Services. You will be satisfied with our services since doing business with us. Definitely, onThesource.com regards customers as our patrons.

http://www.onthesource.com
2009-04-05, 13:11:06
anonymous from Belgium  
It's a real life saver !

C:\Program Files\Borland\InterBase\IB_affinity>ib_affinity -A1

did the job :)
2009-04-06, 01:06:12
anonymous from Canada  
that is a pornstar from usa ravan riley that photo was probably stolen by scammer. thats what they do. they steal photos of innocent people and use it to scam somebody. i talked to about 10 different people saying they were from russia. got all kinds of photos. they are all models or pornstars. or pics they get from their friends .
2009-06-25, 15:52:48
anonymous from Russian Federation  
Hello!! How are you?
I have seen your profile on this site and you have interested me.
I would like to communicate to you more close!!
What do you suspect it?? If you wish to learn about me that my profile you can see on this site also as well as my photo!
I hope that you not against acquaintance and I will wait for your answer.
If you are interested also I to you that was pleasant write on my address of mail Dianakiss123@yandex.ru
I will hope and wait for your answer. On this site I do not know when still I will come therefore write better to me on mail for convenient acquaintance!
p.s Would like to ask you why you have decided to get acquainted on the Internet??


Keywords:
2012-09-22, 21:54:20
anonymous from United Kingdom  
rating
Thank you for the advice. I was experiencing the dual processor delay issue. It was taking 15s to connect to the Interbase database. After using IB_Affinity to fix Interbase on one core, the delay was eradicated.
2012-10-21, 15:21:52
anonymous from Malaysia  
it works! thanks!
2015-01-30, 00:20:27
anonymous from Netherlands  
Hi, I have error:g++ -pthread -lfbclient ibpp/all_in_one.o fcopby/args.o fcopby/fbcopy.o fcopby/TableDependency.o fcopby/main.o -oexe/fbcopyibpp/all_in_one.o: In function `ibpp_internals::GDS::Call()':all_in_one.cpp:(.text+0x5a5): undefined reference to `isc_create_database'all_in_one.cpp:(.text+0x5ad): undefined reference to `isc_attach_database'all_in_one.cpp:(.text+0x5b5): undefined reference to `isc_detach_database'all_in_one.cpp:(.text+0x5bd): undefined reference to `isc_drop_database'all_in_one.cpp:(.text+0x5c5): undefined reference to `isc_database_info'all_in_one.cpp:(.text+0x5cd): undefined reference to `isc_open_blob2'all_in_one.cpp:(.text+0x5d5): undefined reference to `isc_create_blob2'all_in_one.cpp:(.text+0x5dd): undefined reference to `isc_close_blob'all_in_one.cpp:(.text+0x5e5): undefined reference to `isc_cancel_blob'all_in_one.cpp:(.text+0x5ed): undefined reference to `isc_get_segment'all_in_one.cpp:(.text+0x5f5): undefined reference to `isc_put_segment'all_in_one.cpp:(.text+0x5fd): undefined reference to `isc_blob_info'all_in_one.cpp:(.text+0x605): undefined reference to `isc_array_lookup_bounds'all_in_one.cpp:(.text+0x60d): undefined reference to `isc_array_get_slice'all_in_one.cpp:(.text+0x618): undefined reference to `isc_array_put_slice'all_in_one.cpp:(.text+0x623): undefined reference to `isc_vax_integer'all_in_one.cpp:(.text+0x62e): undefined reference to `isc_sqlcode'all_in_one.cpp:(.text+0x639): undefined reference to `isc_sql_interprete'all_in_one.cpp:(.text+0x644): undefined reference to `isc_interprete'all_in_one.cpp:(.text+0x64f): undefined reference to `isc_que_events'all_in_one.cpp:(.text+0x65a): undefined reference to `isc_cancel_events'all_in_one.cpp:(.text+0x665): undefined reference to `isc_start_multiple'all_in_one.cpp:(.text+0x670): undefined reference to `isc_commit_transaction'all_in_one.cpp:(.text+0x67b): undefined reference to `isc_commit_retaining'all_in_one.cpp:(.text+0x686): undefined reference to `isc_rollback_transaction'all_in_one.cpp:(.text+0x691): undefined reference to `isc_rollback_retaining'all_in_one.cpp:(.text+0x699): undefined reference to `isc_dsql_execute_immediate'all_in_one.cpp:(.text+0x6a4): undefined reference to `isc_dsql_allocate_statement'all_in_one.cpp:(.text+0x6af): undefined reference to `isc_dsql_describe'all_in_one.cpp:(.text+0x6ba): undefined reference to `isc_dsql_describe_bind'all_in_one.cpp:(.text+0x6c5): undefined reference to `isc_dsql_prepare'all_in_one.cpp:(.text+0x6d0): undefined reference to `isc_dsql_execute'all_in_one.cpp:(.text+0x6db): undefined reference to `isc_dsql_execute2'all_in_one.cpp:(.text+0x6e6): undefined reference to `isc_dsql_fetch'all_in_one.cpp:(.text+0x6f1): undefined reference to `isc_dsql_free_statement'all_in_one.cpp:(.text+0x6fc): undefined reference to `isc_dsql_set_cursor_name'all_in_one.cpp:(.text+0x707): undefined reference to `isc_dsql_sql_info'all_in_one.cpp:(.text+0x712): undefined reference to `isc_service_attach'all_in_one.cpp:(.text+0x71d): undefined reference to `isc_service_detach'all_in_one.cpp:(.text+0x728): undefined reference to `isc_service_start'all_in_one.cpp:(.text+0x733): undefined reference to `isc_service_query'collect2: ld returned 1 exit statusmake: ** [exe/fbcopy] Erro 1
2015-01-30, 11:34:31
anonymous  
Literally blew me away !. Early early am . Tears your story (yes) This tells me that & it is an affirmation that there is <a href=' http://iurbwp.com'&..</a> person that loves life . That is willing to step into the art of inner . Explorer.When you see my art ;you will understd this comment.B
2015-01-31, 12:16:49
anonymous from Venezuela  
O Firebirtd e muito pticaro , e mais pticaro que interbase e robusto para sua categoria que pena mysql sera mais badalado , ne3o estou desmerecedo o mysql . http://nffthjo.com [url= http://pyoijwpkt.co..wpkt[/url] [link= http://ntwtbaip.com..aip[/link]
You are on page 2 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: