Skip to Content
avatar image
Former Member

for all entries or inner joins ?

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Best Answer
    avatar image
    Former Member
    Oct 21, 2008 at 06:13 AM

    Hi

    Good

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

    JOINS vs. FOR ALL ENTRIES - Which Performs Better?

    Thanks

    mrutyun^

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2008 at 06:13 AM

    Hello ,

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

    My vite is for "for all entries" .

    Rgds,

    Sandeep

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 06:13 AM

    Hi

    Good

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

    JOINS vs. FOR ALL ENTRIES - Which Performs Better?

    Thanks

    mrutyun^

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 06:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 21, 2008 at 06:15 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 21, 2008 at 10:33 AM

    Hi,

    Please go through the following thread...

    Inner Joins vs For All Entries - performance query

    ~Source SDN

    Thanks

    NItesh

    Add comment
    10|10000 characters needed characters exceeded