Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Custom Tables

former_member188791
Participant

‎07-01-2013 4:46 AM

0 Kudos

Hi Group,

I have requirement of receiving 1 million records in to SAP daily through interface we are planning to use custom table for storing this data, can any body suggest if there is any performance issues if we store 1 million records/day in to custom tables.

2 REPLIES 2

Former Member

‎07-01-2013 7:14 AM

0 Kudos

Hi Rajiv,

In the Technical Settings of table creation give the  value 9 for the size category.

Then the memory will get extended dynamically with the same amount if it is completely filled.

Let me know if any clarification/help required.

Thanks & Best Regards.

Pavan Neerukonda.

former_member195402
Active Contributor

‎07-01-2013 7:21 AM

0 Kudos

Hi Rajiv,

there are many possible performance issues.

You need a fast table input program. Don't forget  to call fm 'DB_COMMIT' for releasing system lock table entries many times.

You need large drive space and a huge SAP tablespace where your database table is located.

Any SELECT requests on this table will slow down every day. Therefore you will need several matching secondary indexes for fast acess to the requested data.

It sounds like a great quest.

Regards,

Klaus