Hi Janio,

Links SQL will definately scale up to meet your needs. We have the full import of DMoz (2 Million links and 300,000 categories) and most searches come back in less then 2 seconds. Also, MySQL and the o/s does a lot of caching so while your first search may be slow, future ones will be a lot quicker.

I'd be happy to email you a URL to our DMoz demo (it's behind a DSL line so the internet connection is not great, not suitable for general public).

Our experience is for the best results you should have:

1. mod_perl/fastcgi/speedyCGI installed. This is where you will see your largest performance increase.
2. MySQL 3.23 installed. We have found 3.23 to be significantly faster then 3.22 or Oracle or MS SQL 7.
3. Memory. You should have as much memory as the size of your database. You never want to have to access the disk unless you can avoid it.
4. A fast disk drive. A quality disk drive really helps (u160 SCSI).

Again, you'll find that as the application runs, the O/S and MySQL does a really good job of caching results, so that while a search may take a few seconds the first hit, over time the most popular searches come back right away. You can see this by hitting the Next in the toolbar. It's the exact same search but is significantly faster.

Hope this helps,

Alex

--
Gossamer Threads Inc.