ranges

[Former Member]

what r ranges? what r the number ranges?plzz tell

[Former Member]

Hi,

Due to buffering of huge database table with more number of records from one program then other program do update that database table In other application server then due BUFFER-SYNCHRONIZER which can read DDLOG table and REFRESH the records relevant to that larger database table. So, due to reload of table to application servers it consumes more time.

So, to improve database performance in our program we use NUMBER-ranges.

Here it is maintained in one of database table(NUMBERRANGE TABLE) with current level belongs to one NUMBERRANGE GROUP.

AS u know for a document consist number of records then due to number ranges then for each record at application server can assigned with unique identification number which can belongs to number range group current level read from number range table in database.

And while data can updated to that database table can be stored to that table and new number range level group with number ranges can written to database number range table.

So, for next document they get new unique identification number. And no need of buffering of that huge table with old-records (already available at application server with unique identification number). This avoids buffering of database table. So, database traffic is reduced and no need have refresh of data relevant to that huge table. So, performance can increase.

best regards,

Vijay Mekala

[Former Member]

ranges like selecti-option .right now selecti- optionare using instead of ranges.selection screen gives better perfomence than ranges

Edited by: krishna reddy on Jan 5, 2008 2:04 PM

[Former Member]

it like select-options .select options are better than ranges select options gives better better perfomence than ranges

[Former Member]

Hi Srinath,

Ranges : are being used to assign some default values in the program,its like a select-option,

if you declare it as select option, user have rights to change them before processing the program. where as in Ranges you will define them in program logic.internally you can use them.. say for example.. i wanted to assign some material numbers, based on thease material numbers i wanted to fetch the data..

Ranges: R_MATNR FOR MARA-MATNR.

R_MATNR-LOW = '1000'.

R_MATNR-HIGH = '2000'.

R_MATNR-SIGN = 'I'.

R_MATNR-OPTION = 'BT'.

APPEND R_MATNR.

SELECT MATNR WERKS LGORT

FROM MARD

INTO TABLE ITAB

WHERE WERKS IN R_MATNR.

Thanks,

Murali

Murali.