in reply to Speed of MySQL DBs

Why is it creating these tables? What's the underlying reason?

I have lot's of search scripts, none of them create any tables, they search existing tables, so I'm having trouble understanding what you are doing.

Scott

Replies are listed 'Best First'.
Re^2: Speed of MySQL DBs
by rsiedl (Friar) on Feb 06, 2006 at 02:44 UTC
    A simplistic explanation is:
    Its doing web-type searches and storing the information it finds in mysql tables...
[reply]

      Without more info, it's going to be hard for anyone to give you good advice. Assuming you are using isam tables, MySQL keeps each database in a separate directory and each table as a separate file in the database's directory. If you have thousands of tables, you may run into issues depending on the filesystem.

      Scott

[reply]

In Section Seekers of Perl Wisdom