|
In a DB I'm designing, there's one fairly central table representing something that's been sold or is for sale. It distinguishes between personal sales (like eBay) and sales from a proper company. This means there is literally 1 or two fields which are...
Started by John on
, 7 posts
by 7 people.
Answer Snippets (Read the full thread at stackoverflow):
just remember that as your database evolves you may need to make the decision to refactor to 2 separate tables, (if you need more fields)
If there are two distinct entities, "Personal Sales" and "Company Sales", then perhaps....
I would go for.
|
|
I have a script that needs to extract data temporarily to do extra operations on it, but then doesn't need to store it any further after the script has run. I currently have the data in question in a series of temporary local tables (CREATE TABLE #table...
Started by Margaret on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
Another tables....
Your other approach: To create and then drop regular tables just creates the same overhead.
AFAIK all the tables are treated the same on disk, they just happen to go.
Creating the temporary table.
|
|
I'm working on a project which is similar in nature to website visitor analysis. It will be used by 100s of websites with average of 10,000s to 100,000s page views a day each so the data amount will be very large.
Should I use a single table with websiteid...
Started by Nir on
, 6 posts
by 6 people.
Answer Snippets (Read the full thread at stackoverflow):
You could use MySQL's MERGE storage engine to do SELECTs across the tables broken a huge table into many....
However if you write enough scripting you can do it with multiple tables.
All websites having multiple tables is a pain.
|
Ask your Facebook Friends
|
Hi, I have a fairly huge database with a master table with a single column GUID (custom GUID like algorithm) as primary key, and 8 child tables that have foreign key relationships with this GUID column. All the tables have approximately 3-8 million records...
Answer Snippets (Read the full thread at stackoverflow):
This should improve the performance of the change the tables to modify the old value to the....
This can the tables and recreate after you are done.
The updates of the child tables in batches (one reason not to use cascading updates).
|
|
What is the best way to export data from multiple tables in MySQL. I'm basically working with product details. Say a product has 150 attributes of data. How can I export that in a single row and then export it to a flat file in CSV or tabdelimited format...
Answer Snippets (Read the full thread at stackoverflow):
It is a bit more difficult to create the queries as all the trigger, which is joining several... .
You should be able to come down to 4-6 tables (2-3 entity tables with their attributes).
Extensible, and reduce how many tables you need.
|
|
Say I want to design a database for a community site with blogs, photos, forums etc., one way to do this is to single out the concept of a "post", as a blog entry, a blog comment, a photo, a photo comment, a forum post all can be thought as a post. So...
Started by ray247 on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
This classical essay by Scott Ambler deals to perform less tables to maintain common attributes....
Music', and be on your merry way?
In this case, less tables!
The problem is similar to DB tables is an entirely different question.
|
|
The university I work at uses Oracle for the database system. We currently have programs we run at night to download what we need into some local Access tables for our testing needs. Access is getting to small for this now and we need something bigger...
Started by Clint Davis on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
Could you just copy the Oracle tables and then set them up as linked tables in MS Access? This way are going to just have to write something to sync the data, this is of course always going to run.
|
|
So, I've been having this rather frustrating problem, and having failed so many times, I'm hoping someone here can help me. What happens is these tables on the left side of the page appear fine and do what they're supposed to do when I compile . However...
Started by Justen on
, 3 posts
by 3 people.
Answer Snippets (Read the full thread at stackoverflow):
Change tables to DIVs....
The styling defined with <div class="header"> should just be set on the <h2> tag....
|
|
Hi, i'm trying to join 8 tables into one in order to create index used by other application, my query is like : (my mysql skill's very amateur)
SELECT t1_id, t2_name, t3_name, t4_name, t5_name, t6_name, t7_name, t8_name, t9_name FROM t1 LEFT JOIN t2 ON...
Started by lordlinier on
, 9 posts
by 9 people.
Answer Snippets (Read the full thread at stackoverflow):
Depending on how much data is in the tables, you may need to place indexes with all the tables, instead of putting them in a single query with so many joins, you can possibly try the result you will get will not have 8 ....
From the joins.
|
|
Sometimes we can write a query with both derived table and temporary table. my question is that which one is better? why?
Started by masoud ramezani on
, 4 posts
by 4 people.
Answer Snippets (Read the full thread at stackoverflow):
By using derived tables instead of temporary tables, we can boost our application's performance will require fetching all values....
Derived table is better as temporary tables become more complex when its is used more and more.
|
