Send to a Friend

manuel_alarcon's avatar

What is better: One big SQL query or several?

Asked by manuel_alarcon (299points) February 27th, 2013

Hi, I have relational database and I want to make the most of the data across several tables; for example, a table with sales data and the table with the prices, and another table linking both; I wonder if I want to display that data, and adding counting the data, or any other info I can get from the tables, what’s the best way to do it: build a big fat messy query or several queries, each one depending on the previous one? I don’t want the site to get sloppy

Using Fluther

or

Using Email

Separate multiple emails with commas.
We’ll only use these emails for this message.