Community
Application Development and Automation 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: 
Read only

Table data update problem in Production and development clients

Former Member

‎2008 Nov 13 10:29 AM

0 Likes
423

Dear Friends,

I have typical question,

I have a Z table in my development server ( its new one ) and we did some changes and activated it, but we didn't adjusted the table now we moved it to production in production we trying to update the table with some data but to update the table with minimum data ( 2000 records ) its taking a long time ( 30 mins ) , similar problem we faced in development server but after I adjusted the table its working very fast ( within 20 seconds ),

Please let me know if we didn't adjusted the table dos it take max time? the table is same in development and production also even the data also.

( after that I have created another new request and moved to production with adjustment but no change)

we donu2019t have any authorizations to adjust the table in production , how to resolve it????

Thanks,

Sridhar Reddy

Dear Friends,

I have typical question,

I have a Z table in my development server ( its new one ) and we did some changes and activated it, but we didn't adjusted the table now we moved it to production in production we trying to update the table with some data but to update the table with minimum data ( 2000 records ) its taking a long time ( 30 mins ) , similar problem we faced in development server but after I adjusted the table its working very fast ( within 20 seconds ),

Please let me know if we didn't adjusted the table dos it take max time? the table is same in development and production also even the data also.

( after that I have created another new request and moved to production with adjustment but no change)

we donu2019t have any authorizations to adjust the table in production , how to resolve it????

Thanks,

Sridhar Reddy

Reply
1 REPLY 1
Read only

Former Member

‎2008 Nov 13 2:32 PM

0 Likes
342

Hi Reddy,

If you adjusted the table in development client and transported to production, table in production will be automatically adjusted. Even if it is taking much time to update the table, check the code whether you have written the update statement inside a loop or outside. If you update the table inside a table it will take some time, as for every loop it will hit the data base. We can update a table directly from itab.

keep your all entries in a itab and then update.

Regards,

Subhani.