for all entries or inner joins ?

[Former Member]

Hi friends,

Could u please tell me as per performence

which one is good for all entries or joins to get data from multiple tables??

regrds

Kiran

[Former Member]

Hi

Good

Please check the below SDN blog hope this will help you to solve your problem.

Thanks

mrutyun^

[Sandeep_Kumar]

Hello ,

It depends how many records and how many number of tables you are using.

My vite is for "for all entries" .

Rgds,

Sandeep

[Former Member]

Hi

Good

Please check the below SDN blog hope this will help you to solve your problem.

Thanks

mrutyun^

[Former Member]

hi kiran,

for all entries is better performance wise because in that database is accessed only once where as in inner join it chwecks each entry.. which takes alot of time wid database.

regards

palak

[P561888]

Hi ,

It depends on the table records,

if the table contain the more that 60000 records better dont go for For all entries...

Regards,

Bharani

[Former Member]

Hi,

Please go through the following thread...

~Source SDN

Thanks

NItesh