This info can be usefull for some guys who are working on bigger projects
and their sites will have 50k links and more.
Our site has 50k links and we are getting 70.000 unique hits per day,
without Mysql links version i doubt that our server will be able to handle
such a big traffic,we have been on virtual host ,now we have move everything
to dedicated server ,we have tweak whole system or cgi`s will eat too much
of resources ,this must be done under linux too,if you are using basic httpd
configuration (256 www client reguests per second),with 70K hits per days you
will not be able to handle that.If you have 50k links and about 1--5k hits
day ,you can still be on virtual host,but some hosting companies can delete you
because you will eat them a lot of resources ,without notice.
There is a simple solution,if you dont have much money to spend on
dedicated servers,order virtual hosting at company that uses RAID mirroring
disks,dont forget to ask admins if they allow you to run that type of site
under virtual hosting plan.If your site gets big some day,you can easily
move to dedicated server,without changing permission on each file,RAID
will create,exactly the same mirror you have on virtual hosting plan.
Sorry for my not soo briliant english,hope
this message will help someone,who is thinking about running bigger projects
with Links SQl.
Specification of our dedicated server:
OpenBSD
Pentium III 600
256MBR
20GB HD
10/100mb ethernet
apache webserver