Slow Performance in Sales Orders for Orders with many rows

[Former Member]

Hi Experts,

My customer often adds Sales Orders with 300+ rows. It takes a long time when the user gets towards the end, taking 30 seconds to show the Item Description having entered the Item Code when adding another line.

I have removed all Formatted Searches and tested in a seperate environment, but the performance is still slow.

Does any one have any suggestions? I have tried on 2007 PL42 and PL49

Regards

Greig

[Former Member]

Logged message with SAP

[msundararaja_perumal]

Hi,

Refer this note:1262284

[Former Member]

Hi Greig,

1.What is your DB Size ?

2.What is your Hardware Configurations ?

3.SAP B1 Using through Citrix ?

4.300 lines or More than 300 lines are entered in sales order then only the slow

performance or what ?

Regards

Jambulingam.P

[former_member186095]

Hi,

This seems to be a hardware and requirement issue. We also have customer that oftentimes creates more than 100 items in row and they are using SBO 2005A SP01 PL52 in high speed sever and high RAM size. I think you could try to use RAM is 4 gb and quad core in the server and 1 gb in the workstation.

Rgds,

[Former Member]

What are your server and/or client hardware configurations? That will make big differences.

Thanks,

Gordon

[Former Member]

HI Greig,

database operations normally needs RAM. If you got hugh queries - which a order with 300 rows is - you should be sure to have enough performance at your server.

So what is the hardware configuration.

Also - as already posted - shrink and index - your SQL server database.

Regards Steffen

[Former Member]

Hi,

I have Shrunk and Indexed the DB but it has made no difference.

Greig

[Former Member]

Hi Bishal,

How would I go about indexing the database?

Thanks

[Former Member]

Hi Greig ,

Couple of things could be done :

1.Indexing - to increase database performance

2. When you click itemcode >limit your selction to only like ItemCode and description only

Since it is not usuual to have 300+ rows of order lines ...I donot have specific solution to suggest ..

Hope this helps

Bishal

[Former Member]

Hi Greg ,

Lets try from SAP knowleadegebase before we do indexing as indexing is like database tuning .

1.Shrink your database

2 .Run the script in Sql server

Use Database name go

sp_updatestats

3.Apply latest service pack

4.Eliminate the fields from Form setting which is if free text like Item Remarks ..free text .

Please take a backup before you do anything .

Hope this resolves your issue

Thank you

Bishal

Edited by: BIshal Adhikari on Jul 30, 2009 8:37 AM

[former_member187989]

Hi greig,

Why not try DTW which will be much faster than manual entry ?

Use oOrder template,in which use Document template for header level datas,Document_lines for item level datas.

Jeyakanthan