Re: Increasing table access times

Steve Harris wrote: > > Hi, > I'm involved in admin of a Baan (ERP) system (using level 1 drivers) running > on Solaris 2.6 using IDS 7.30.UC10. We are experiencing wierd table access > problems. We can run a report which will use only a few tables. When we > monitor the access time of the tables the intial access is fine but > subsequent accesses slow down and continue to do so. I've done all the > usual, extent tuning, export/import. It appears to be that once the ESQL > command is executed that any further GTEQ calls that are issued appear to > slow down. > > Has anyone experienced something similar with Baan. All the time. I thought it was how Baan was designed! :-) I still like the phrase used by one Spanish poster on this list; "This Baan code is a shit!" You need to determine where the delay is, in the database, in the transfer (network?) or in the Baan code. If you've tuned the database server and you haven't seen any network problems, then you probably have it nailed. Cheers, -- Mark. +----------------------------------------------------------+-----------+ | Mark D. Stock mailto:mdstock@mydas.freeserve.co.uk |//////// /| | http://www.informix.com http://www.informixhandbook.com |///// / //| | http://www.iiug.org +-----------------------------------+//// / ///| | |What year 2000 bug? year 2000 bug? |/// / ////| | |year 2000 bug? year 2000 bug? year |// / /////| | |2000 bug? year 2000 bug? year 1900 |/ ////////| +----------------------+-----------------------------------+-----------+