thank you for your prompt answer.
[quote]This isn’t really an answer to your question, but just a tip: >Try to resist the urge to store the actual MP3s in the database. While it’s possible to do with BLOB column types, it can make things rather hard to code and can slow down your database access.
Instead, store the files in the file system itself and store paths to them in the database.
Your tip is already implemented
[quote]As an aside, what aspect of this site do you think will be so heavy? Will it be accessed by many people, or were you planning to do something specific with it that seems rather CPU intensive? If you can give us an idea of what you’re planning on, I’ll be happy to give you some ideas on optimizing database performance (which may help, no matter which host you decide on).
I have published this site at http://www.tucantucan.com and responce time is about 30 sec for main page, that is completle unacceptable for me.
I do have made several tests on local network to estimate my responce times. Even Pentium-100 was performing all tasks at blazing speed. At this point I am unable to answer is that site is CPU intensive or is it hosted on overloaded PHP+MySQL server.
I expect to have 300 visitors per day, with avarage 50-100 MySQL queries per visitor.
Jeff, I would very appreciate if you visit mentioned site to have an idea what I am up to. It would be my pleasure to provide any additional information.