performance issue in smart forms

[Former Member]

Hi all,

I am making some smartform in HR and whenever user is generating the form, I am storing all the dynamic fields in a ztable and assigning this set of values a unique key in the table so that whenever a user wants to generate the same smartform in future again, he can do so by using this unique key.

Now my concern is that I am storing all the dynamic fields like personal area text and designation text etc. in that z table. Whenever i am using the unique key to generate that form, its going into that z table and fetching the values from there on the basis of unique keys. Imagining that there are 50000 records in that table, will it be better performance wise it I just store the key codes of fields like personal area text and designation text etc. and while generating the form, and fetching the values wrt. key, I get the texts from different tables using these key codes of fields like personal area text and designation text etc. or it makes no difference if i store complete personal area text and designation text etc in the ztable and while genetating form i can get all the values from that single line of ztable using the key???

Another concern which i have is that wheather an inner join is better or 3-4 'Select Single' statments are better performance wise? - In other words suppose if I want to pull out single record - different fields from different tables of one personal number, should I use select single on all those table or is join better n that case too????

Thanks

Ribhu

[Former Member]

Hi,

Whenever a case of regeneration of smart forms in future the procedure followed to use Z-table as storage is normal.

Reply to Concern (1)

************************

It is better to store all values in the Z-table rather than " select single text for fields" based on value from Z-table because otherwise again a database operation is performed for every select single operation.

For one or two text fetch using select single,performance is not an issue but when it comes to multiple rows and coloumns and text for all these it may worsen performance(time consuming)

Reply to Concern (2)

************************

For multiple table linkage from 3-4 inner join is advisable.

Always try passing key fields which is always going to boost up system performance and add filtering as and when required.

Regards

Byju

[Former Member]

Hi Byju,

Thanks for your reply. Well aone more small concern - While fetching the data from a z table with all the fields, will it take more time - performance wise than if i store key fields in z table and use inner joins for getting texts in smartform - which of the two would be better.

If I store all the data from infotypes, there would be a lot of repetiton of data like employee name, designation etc.

So which thing I sholud use of the two????

Thanks for your advice.......

Regards,

Ribhu

[Former Member]

Hi Ribhu,

The following is the idea i have....

when you are reading data from Z-tables

a)Multiple entry case--->

if you are doing read table for internal table again for a very large number of records...performance decreases

ie..

select * from Ztable into Itab where ZABC = 'ABC' and....

and read table itab with key XYZ. (itab has large number of lines..? then performance issue)

Here innerjoin on key fields of HR tables may prove better if you are reading single text for smart forms

b)Single entry from ZABC case

select single * => O.K than innerjoin

when you are storing data from HR try to fetch latest data from HR by using BEGDA-ENDDA combination as key fields in Ztable.If the Ztable itself contains as much data as in standard tables it is advisable to use inner join since existance of Ztable serves no purpose.

Hope this clarifies you...

Thank you and welcome(glad to be of any help)

Byju

[Former Member]

Thats a perfect reply Byju. My g mail id is ribhuahuja@gmail.com. Whats urs?

Waiting for your reply to close the thread.

Regards,

Ribhu

[Former Member]

Hello Ribhu,

I am glad that my suggestions proved useful and thanks for the appreciation

You can reach me at shadowcatbx@gmail.com

Regards

Byju