•
•
•
•
What is DaniWeb IT Discussion Community?
You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 456,488 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,734 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.
Please support our MySQL advertiser: Programming Forums
Views: 1019 | Replies: 1
 |
| |
•
•
Join Date: Aug 2007
Posts: 5
Reputation: 
Rep Power: 0
Solved Threads: 0
Newbie Poster
What are the performance implications of storing some data across 2
databases instead of duplicating this data in both databases? ie. is
example 1 significantly slower than example 2:
Example 1:
SELECT Users.User.*, Transactions.Sales.date
FROM Users.User, Transactions.Sales
WHERE Users.User.id=Transactions.Sales.userid;
Example 2:
SELECT Users.User.*, Users.Sales.date
FROM Users.User, Users.Sales
WHERE Users.User.id=Users.Sales.userid;
Note in Example 2 the database Users would be significantly larger as
it has data duplicated from the database Transactions.
Thanks for any help.
databases instead of duplicating this data in both databases? ie. is
example 1 significantly slower than example 2:
Example 1:
SELECT Users.User.*, Transactions.Sales.date
FROM Users.User, Transactions.Sales
WHERE Users.User.id=Transactions.Sales.userid;
Example 2:
SELECT Users.User.*, Users.Sales.date
FROM Users.User, Users.Sales
WHERE Users.User.id=Users.Sales.userid;
Note in Example 2 the database Users would be significantly larger as
it has data duplicated from the database Transactions.
Thanks for any help.
|
•
•
•
•
•
•
•
•
DaniWeb MySQL Marketplace
•
•
•
•
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
Hybrid Mode
Similar Threads
- fstream Tutorial (C++)
- Help on General Best Practices for Table/Database Design (Database Design)
- Autonumber in a SQL Server table (MS SQL)
- 32bit vs 64bit software performance comparison(under Windows XP 64bit) (Motherboards, CPUs and RAM)
- One script, multiple databases (MySQL)
- Multiple databases/separate sites in mysql (MySQL)
- Interface page for my new database... (MySQL)
- Error getting forms to send information (PHP)
Other Threads in the MySQL Forum
- Previous Thread: war FILE and DataBase
- Next Thread: Open Source Application Server
