Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: cristiancodreanu
- Order by date
-
associative tables, query optimization
Tanks r937, I will try that!- cristiancodreanu
- Post #15
- Forum: MySQL
-
associative tables, query optimization
thanks, I will try that too (I will have to add to it my WHERE condition though :p)- cristiancodreanu
- Post #11
- Forum: MySQL
-
associative tables, query optimization
Thanks for pointing that, r937. book_author should not be there. However, this is not the real database I'm having problems with, this is meant to serve as a concise illustration of the problem. Unfortunately GROUP_CONCAT does not help much, the join would still be huge (5 tables again) and I...- cristiancodreanu
- Post #9
- Forum: MySQL
-
-
associative tables, query optimization
@r937: this is one of the reasons for sure. But the main problem is the huge (even for only few records in the tables) cartesian product of those 5 tables.- cristiancodreanu
- Post #5
- Forum: MySQL
-
associative tables, query optimization
the above tables are just to illustrate the problem, the real DB being more large (and the tables have more columns). The indexes are on the 'id' fields. Any advices? Thanks.- cristiancodreanu
- Post #3
- Forum: MySQL
-
associative tables, query optimization
Hello I am using associative tables in a database and I have problems when I have to simultaneously query multiple tables. As a simplified sketch of what I mean, these tables are given: books: book_id, book_title, book_author authors: author_id, author_name books_authors_assoc...- cristiancodreanu
- Thread
- Replies: 15
- Forum: MySQL
