Hi,

currently I run a webserver with Windows 2000, where I have the
following three parts
1) Firebird 1.5 as database
2) Apache 1.3 / PHP 4.4 for the website. To speed up the site a create
a hash on the url's and use that as cache file name. So during one
week the number of cache files goes up over 100'000 files
3) Delphi 2007 application for some background tasks and as http
service to provide graphics.

Because of size of the database and number of requests the website is
rather slow now and I think of adding a second machine. Before I do
this, my questions are:
- What parts (1 - 3) should I put together? Should I use the new
machine as a database server only? Or should I separate the Delphi
2007 application?
- Should I consider to setup the new machine with Linux?

Any other hints, also how to find out, what makes the system slow and
how it could be improved? I already checked all SQL statements and I
think, there is none that causes a problem with a wrong plan or
missing indexes.

cu Christian