topic Re: need help with performance in Application Development and Automation Discussions

need help with performance

Former Member — Tue, 19 May 2009 15:42:47 GMT

Please use a meaningful subject in future

i have to create table with users (10.000) users and additional data,and there is a process

that read the table data and see if something changing update the table.

Most of the data is to are not changing frequently like 90% from the time .

What is your suggestion to use,i don't know if fully buffered table can help here because the table size.

I'll like to get your suggestion's if to use table buffer or shared memory object ?

best regards

Nina

Edited by: Nina C on May 19, 2009 10:39 PM

Edited by: Matt on May 20, 2009 2:55 PM

Re: need help with performance

former_member207438 — Tue, 19 May 2009 17:52:05 GMT

Why are you anticipating performance problems?

10000 records does not sound like a lot.

I'd suggest you create your table without buffering and test the performance on your development system.

Then, if you have a particular SELECT statement, for example, that runs slow, you may need to address a performance problem.

Re: need help with performance

Former Member — Tue, 19 May 2009 18:00:38 GMT

hi,

if the user or any one frequently accessing the table it is better to use buffering.

if they update or read table rarely then there is no need to use buffering.

table size depends upon how the data is updation and what is the amount of data update in one run..

for one run if they update more than 10000 records create table size 2 or 3.

if they update less records at a time keep table size 0.

Prabhu

Re: need help with performance

Former Member — Tue, 19 May 2009 20:46:08 GMT

HI Prabhu,

Thanks,

What do u think about single row buffer or shared memory object ?

By the way we can use the table until 30000 rows.

Best regards

Nina

Re: need help with performance

Former Member — Tue, 19 May 2009 20:46:22 GMT

HI Prabhu,

Thanks,

What do u think about single row buffer or shared memory object ?

By the way we can use the table until 30000 rows.

Best regards

Nina

Re: need help with performance

Former Member — Tue, 19 May 2009 20:46:25 GMT

HI Prabhu,

Thanks,

What do u think about single row buffer or shared memory object ?

By the way we can use the table until 30000 rows.

Best regards

Nina

Re: need help with performance

Former Member — Tue, 19 May 2009 20:46:32 GMT

HI Prabhu,

Thanks,

What do u think about single row buffer or shared memory object ?

By the way we can use the table until 30000 rows.

Best regards

Nina

Re: need help with performance

Former Member — Tue, 19 May 2009 20:46:35 GMT

HI Prabhu,

Thanks,

What do u think about single row buffer or shared memory object ?

By the way we can use the table until 30000 rows.

Best regards

Nina

Re: need help with performance

Former Member — Tue, 19 May 2009 20:48:28 GMT

HI ,

Thanks,

What do u think about single row buffer or shared memory object ?

By the way we can use the table until 30000 rows.

Best regards

Nina

Re: need help with performance

Former Member — Wed, 20 May 2009 05:17:32 GMT

HI Prabhu,

Thanks,

What do u think about single row buffer or shared memory object ?

By the way we can use the table until 30000 rows.

Best regards

Nina

Re: need help with performance

Former Member — Wed, 20 May 2009 05:52:37 GMT

Hi Nina,

I believe using a generic buffering table will be the best one...

you can specify the number of key fields based on which the generic buffering has to be done.... that will also improve on performance....

and I also think that since it is on around 10-20 thousand records even fully buffered will also be fine...

Regards,

Siddarth

Re: need help with performance

Former Member — Wed, 20 May 2009 06:39:09 GMT

HI Siddharth

Thanks,

i read that generic buffer is recommended until size of 10MB , i think that the table is

for 30000 records ,

1. how i can calculate it ?

2. about generic buffer ,if i understand from the SAP help i need for that do declare specific

area that be buffered but i don't know which area ,in any given time any records in the table

can be read or change,so how u suggest to do so ?

Best regards

Nina

Re: need help with performance

Former Member — Wed, 20 May 2009 06:44:45 GMT

alright...

so if that is the case then single buffering will not help you that much..... as for the first time it will hit database again and again for new records....

I think its better to go for fully buffered or generic buffering...

to calculate 10MB just check the size of the columns means size of each row/record. that can be calculated by fields you have declared and i think for 10MB it can almost accomodate more the 10000 records.... still depending on the size of each row...

Either of fully/generic buffering would be fine for the performance...

Regards,

Siddarth

Re: need help with performance

Former Member — Wed, 20 May 2009 07:31:20 GMT

HI Siddharth,

about generic buffer ,if i understand from the SAP help i need for that do declare specific

area that be buffered but i don't know which area ,in any given time any records in the table

can be read or change,so how u suggest to do so ?

Best regards

Nina

Re: need help with performance

Former Member — Wed, 20 May 2009 07:38:15 GMT

Thats true that you have to mention a specific area.... that specific area is nothing but the number of key fields you want to mention...

now say for example... if you look at the table sflight it has 4 key fields but i want the generic buffering to be done with respect to carrier ID, so for one carrier id there may be many records on connid and fldate. so if i give carrid in my select query all the records of that carrier id only will be buffered....

so the key specification i would mention it as 2. that is from the left based on 2 columns it should buffer.

so give the generic buffering in such a way that it will buffer most of the records at a given time. so next time if you use any f those records it would be faster.

so if you have 5 key fields give the area ie. key specification to 1 or 2... so that it buffers most of the record at a go....

I think going with generic buffering will be better....

Regards,

Siddarth

Re: need help with performance

Former Member — Wed, 20 May 2009 11:23:12 GMT

> Most of the data is to are not changing frequently like 90% from the time .

95% not changing, means 10% changing, actually I do not understand what you count, rows or executions?

Anyway, 10% is too high for table buffering, especially for fully buffered tables. For example

10.000 records, full buffered, i.e first SELECT reads whole table.

90 records from buffer, then change, buffer invalidated! all 10.000, after a while buffer filled again.

=> with buffering worse than without.

How often is table changed? How large is your system, several application servers?

What are the statements?

Siegfried

Re: need help with performance

matt — Wed, 20 May 2009 12:55:30 GMT

Please use a meaningful subject in future