1: No.
2: It depends on a lot of things. If your site traffic is heavy and you can
split your data into discrete elements, you could possibly get better
performance by splitting your data into separate databases and running them
on different servers.
Cal
http://www.calevans.com
-----Original Message-----
From: Rus [mailto:[EMAIL PROTECTED]]
Sent: Sunday, February 11, 2001 12:38 PM
To: [EMAIL PROTECTED]
Subject: Performance Q
Hi!
Does MySQL open all tables in database when I select data from one table?
Will it be faster to split db to number of smaller db associated with
concrete PHP scripts?
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
