View Single Post
  #1  
Old 23rd March 2005, 14:45
lakoon's Avatar
lakoon lakoon is offline
Senior Member
 
Join Date: Jul 2003
Location: Switzerland
Posts: 179
lakoon is on a distinguished road
Baan: Triton 2.0, Baan IV b/c /ERP /ERP LN - DB: Oracle / tbase / MSSQL - OS: Solaris / HP /Windows
slow performance on tfgld418

Hello

We face the problem thet the booking of material receipts for project items is very slow. for standard items the booking performance is o.k.

We checked with the ORAPROF options and get for always the following result for project items:

------ Profiling value exceeded -----
<fcper><tdpur4120m000>:2005-03-23[12:50:56.265]:
Time (parse) : 0.000000 seconds
SQL statement:
SELECT /*+ FIRST_ROWS index(a ttfgld418100$idx1) */ MAX(a.t$sern) FROM baandb.ttfgld418100 a WHERE a.t$ocom = :1 AND a.t$tror = :2 AND a.t$fitr = :3 AND a.t$trdt = :4 AND a.t$trtm = :5
-------------------------------------
------ Profiling value exceeded -----
<fcper><tdpur4120m000>:2005-03-23[12:50:56.265]:
Time (multi_exec) : 0.000000 seconds
SQL statement:
SELECT /*+ FIRST_ROWS index(a ttfgld418100$idx1) */ MAX(a.t$sern) FROM baandb.ttfgld418100 a WHERE a.t$ocom = :1 AND a.t$tror = :2 AND a.t$fitr = :3 AND a.t$trdt = :4 AND a.t$trtm = :5
-------------------------------------
------ Profiling value exceeded -----
<fcper><tdpur4120m000>:2005-03-23[12:52:21.280]:
Time (multi_fetch) : 85.015000 seconds
SQL statement:
SELECT /*+ FIRST_ROWS index(a ttfgld418100$idx1) */ MAX(a.t$sern) FROM baandb.ttfgld418100 a WHERE a.t$ocom = :1 AND a.t$tror = :2 AND a.t$fitr = :3 AND a.t$trdt = :4 AND a.t$trtm = :5
-------------------------------------

As the table has more then 10 million records we did not reorganize it yet.

Do you now a similar problem, and if, how did you solve it?

Thanks for your help

/lakoon
Reply With Quote