Hi all, i have a MySQL driven web system that searches a pretty big DB of property info. (10 data tables, about 50,000,000 total rows, average 300 concurrent users)
There are actually 2 databases that feed this site, one is meta info, and isnt hit that heavily. Lets call those DB's 'data' and 'metadata'. So my perl cgi handler creates a MySQL DBI connection to the 'data' db. When i need info from the 'metadata', i see a couple options. 1) issue query 'use metadata'. Do whatever. issue query 'use data' 2) dont change DB's, but have all queries into 'metadata' explicitly name the tables, like '... metadata.some_table...' I was wondering if either method has better performance. They seem about the same to me. Oh, im using InnoDB with the innodb_file_per_table setting. The 'data' DB is on a separate physical drive from 'metadata' Any thoughts? need more info, let me know? am i being too anal? thanks much sean peters [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
