Re: Joining several multi-to-multi tables
Yes, I know, but let's say that someone has 100 email address and 100 phone numbers. That means sql has to group 10,000 rows to pull out one user. If I need to load all the users, the load on the server would be tremendous and it may even crash (I've seen it happen before). The problem is not loading the data so much as it is the unbelievable load on the server when there become a lot of rows. I hope this explains my problem...
Subject
Views
Written By
Posted
3633
June 20, 2006 11:59AM
1877
June 20, 2006 12:14PM
Re: Joining several multi-to-multi tables
1972
June 20, 2006 12:21PM
1892
June 20, 2006 01:02PM
1943
June 20, 2006 01:44PM
1916
June 20, 2006 04:23PM
1884
June 20, 2006 06:02PM
2042
June 23, 2006 06:58AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.