Re: Performance Q

2001-02-12 Thread Tõnu Samuel
Rus wrote: > > Hi! > Does MySQL open all tables in database when I select data from one table? No. But he will keep last x ones for faster access. My my.cnf file: [tonu@no tonu]$ cat /etc/my.cnf [mysqld] log-slow-queries=/var/log/mysql-slow-query.log set-variable = long_query_time=1 set-variab

RE: Performance Q

2001-02-11 Thread Cal Evans
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

Performance Q

2001-02-11 Thread Rus
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?