visitor (0 QPoints)
  • FR
  • EN
  • NL
  • DE
  • ES
294 experts, 1172 registered users, 1625 questions already answered
European Experts Exchange, the very best site for high-quality IT solutions

New Improved Search!

 


The DDRK link is back online.
We got a one week service interruption, sorry.
(23-30/01/2010)

Databases :: MySql :: Storing/Retrieving Data in Multiple Databases
By: Squibi U.S.A.  Date: 11/07/2003 00:00:00  English  Points: 75 Status: Answered
Quality : Excellent
Hi

I am quite new to mysql and wondered if anyone could highlight any problems that may arise
with the following implementation.

I plan to have one database for storing all application specific data, however the main data for the
application is huge (up to 100 MB per file) and needs to be stored also. I plan to create a new DB
for each Project and store the project data in this data base - creating a new table for each file and storing
the table name in the main application database.

The reason is that I may have 1000-100000 records in anyone file I need to store. Creating a lot of
tables in the same database is apparently not advised and I think the 4GB file max would be reached
sooner rather than later. I also want to reduce the degredation in performance to a minimum!

What would the overheads involved in switching between different databases to retrieve data?
How does mysql handle this?
Does connection to first DB have to be closed? (By the rdbms)


Any guidance on this issue would be much appreciated.

Thanks in advance

LittlePerson
By: Ice_S5 Date: 11/07/2003 02:34:00 English  Type : Assist
Check:

HREF="http://www.experts-exchange.com/Databases/Mysql/Q_20632901.html
By: VGR Date: 11/07/2003 03:05:00 English  Type : Answer
ther's no noticeable overhead. I also had once to use such a structure (a table containing database names)

Do register to be able to answer

 Add This Article To:
 del.icio.usDel.icio.us  diggDigg  googleGoogle  spurlSpurl
 blinkBlink  wongWong  simpySimpy  yahooY! MyWeb 
EContact
browser fav
page generated in 61.697010 milliseconds

Why Google AdSense ads ?
compteur
 Ranking-Hits PageRank for this page