topic select single help in Application Development and Automation Discussions

select single help

Former Member — Sat, 23 Jun 2007 16:55:23 GMT

hallow

i use in my program a select single statment but i heard that it bed for performance

but every time i work with one row like select person ,name ,id,pernr..and contnue with data of person

which metod i have to use for better performance

Regards

Re: select single help

Former Member — Sat, 23 Jun 2007 16:57:02 GMT

Hi,

Generally if you have the full primary key you should use SELECT SINGLE..

Otherwise to get one row..you can use SELECT UP TO 1 ROWS..ENDSELECT with the WHERE CLAUSE.

Thanks

Naren

Re: select single help

Former Member — Sat, 23 Jun 2007 21:10:20 GMT

Its not true that select single is bad for performance. Select Single is used to fetch distinct record from db table which is possible only by giving all key fields.

Select single without all key fields will not fetch the distinct 1 record but any one of the records which satisfy the conditions.

There is no difference in the performance between the 2 statements. Just that you will get a EPC warning when you give select single without all key fields.

Regards

Navneet

Re: select single help

Former Member — Sat, 23 Jun 2007 23:45:21 GMT

use select single - When ever you have primary key

use select upto 1 row - if you do not have proper primary key condition in where caluse for select single then go for select upto 1 row.

And also Better to write the code outside of the loop by using for all entries condition ,then use read table within table -> which gives better performance.

Thanks

Seshu