IBM Security i2

Expand all | Collapse all

ibase and analyst notebook extremely slow when retrieving records

  • 1.  ibase and analyst notebook extremely slow when retrieving records

    Posted Wed December 23, 2020 12:33 PM
    Edited by makcim s. Thu December 24, 2020 06:19 AM

    Hi, 

    I wanted to know if there are any plans to provide a 64 bit version of iBase/analyst notebook. I work at a bank and when there are many records ibase starts getting extremely slow. 

    I noticed that the x86 applications most certainly have to be the culprit, due to being limited to 4GB of ram, despite having more than 30GB allocated to the server I'm running ibase at.

    Is there any way to bypass that 4GB limit when using i2?

    Regards



    ------------------------------
    makcim s.
    ------------------------------



  • 2.  RE: ibase and analyst notebook extremely slow when retrieving records

    Posted Thu December 24, 2020 03:01 AM

    Hi Makcim,

    Can you tell me what version of iBase you are running? Is your database on a remote machine? If so, the most common culprit for a slow iBase is network speed.

    Best regards



    ------------------------------
    Jan-Willem Lapoutre
    Senior software developer
    DataExpert b.v.
    Veenendaal
    ------------------------------



  • 3.  RE: ibase and analyst notebook extremely slow when retrieving records

    Posted Wed January 27, 2021 09:10 AM

    Usually, notebooks and PCs do run slow because there is a virus, you haven't defragmented it for a long time, and if it has aged, its because the HDD is slowing down its RPM speed

    want the easy way but you will lose all your files? the easy way to do it is to replace your HDD with a blazing fast SSD, however, that will cost you around $100 or more

    Source: Advantages of WhatsApp sniffer



    ------------------------------
    john janny
    ------------------------------



  • 4.  RE: ibase and analyst notebook extremely slow when retrieving records

    Posted Thu December 24, 2020 06:19 AM
    Edited by makcim s. Thu December 24, 2020 06:21 AM

    Good morning,

    I'm running iBase 8.9.11. It's connected to the database through the network, but we're running other IBM products which consume data from a database via network without taking much of a performance hit. 

    As I said, when checking task manager in Windows Server, just doing a couple of queries iBase it's hitting RAM limit at 4GB.

    Happy Holidays



    ------------------------------
    makcim s.
    ------------------------------



  • 5.  RE: ibase and analyst notebook extremely slow when retrieving records

    Posted Thu December 24, 2020 07:44 AM

    Hi Makcim,

     

    In that case you should really look at the iBase 9. It is not 64bits but has a huge performance increase. It is much quicker than the previous versions. They also changed the way it communicates with the database. It now needs less communication.

    They removed some progress bars because it was that much quicker, that there wasn't a need for it anymore.

     

    Performance also depends on what you are doing. I have seen in the past that a user created the wrong queries, without knowing that. Or simply forgot to index the database.

    Another unexpected way to decrease performance was a verry full logging database (never cleaned it) or a database with a lot of soft deleted records.

     

    I know what you are saying about maxing the RAM, but in my 20 year with iBase I have never seen that being the real cause of performance issues…..which doesn't mean I wouldn't like to see a 64bits version. YES PLEASE! It would off cause in crease the performance even further.

     

    With best wishes for the new year.



    ------------------------------
    Jan-Willem Lapoutre
    Senior software developer
    DataExpert b.v.
    Veenendaal
    ------------------------------



  • 6.  RE: ibase and analyst notebook extremely slow when retrieving records

    Posted Thu December 31, 2020 11:32 AM
    Hello Makcim

    I agree with Jan-Willem that you should move to iBase v9 as soon as possible.  I have seen it demonstrated and it is significantly quicker than v8.9.x - it is because the back-end has been recoded to make it more efficient.  I too have been asking for 64-bit iBase / ANB, and from chattng with the developers at IBM that wasn't possible with the old coding.  Hopefully now this recoding has happened, it should be on the cards for a future release.

    How quickly you can move to iBase v9 will depend on how many users you have.  To get the benefits, the database itself has to be updated by opening it in iBase Designer v9.  Once that has happened, anybody running an older install will not be able to open that database.  If it is just yourself and a small team, that will probably not be a problem, but we have around 180 users so we are having to carefully plan our upgrade.

    Just one more point that may help you right now.  There is a known memory leak within iBase - certainly within iBase v8.9.11 (which is what we are still using) and older.  Over time, this causes the SQL Server to use up more RAM so that even running simple searches takes a long time, and eventually the SQL server crashes.  We found that this crash happened around every 5-6 months.  I don't know the precise details around the issue as I am not a SQL-trained DBA.  The solution is to reboot the SQL Server and clear the RAM.  We now have a regular re-boot once a month to avoid it slowing down then crashing.   This may not be the cause of your issue, but it is worth mentioning in case it helps.

    Have a good New Year.


    Ant

    ------------------------------
    Anthony Patamia
    ------------------------------



  • 7.  RE: ibase and analyst notebook extremely slow when retrieving records

    Posted Mon January 04, 2021 08:21 AM
    Thanks for the additional information. We have a way smaller team than yours, but still will have that in mind. We have v8.9.12 and so far didn't seem to have any memory issues. 

    Happy new year! Hope we get x64 in 2021!

    ------------------------------
    makcim s.
    ------------------------------