Gossamer Forum
Quote Reply
Upgrade
I have a small site using links v2.0 and its now becoming a bigger site. The search and general use has become slow I want to upgrade to the SQL version but wanted to know

1. If I use LinksSQL would it become faster compared to the normal Links v2.0 - compared to the amount of listings

2. Can I upgrade from links v2.0 to Links SQL and transfer my current listings

Thanks a Million

Quote Reply
Re: Upgrade In reply to
Yes Links SQL will be faster as it uses mysql and not a flat file database so can store more data more efficiently.

Yes you can import all your Links2 data straight from the Links SQL admin panel.

Installations:http://www.wiredon.net/gt/
Favicon:http://www.wiredon.net/favicon/

Quote Reply
Re: Upgrade In reply to
As always, there is the answer, then the modifiers :)

If you have an account sufficient to run Links SQL, that means reasonable CPU, reasonable disk space, and access to MySQL, then it will be faster, and actually use _less_ system resources than a large flat-file database.

BUT... you need more resources to set the system up. The flat file system runs on almost any account, until it gets big, but Links SQL has certain minimum requirements that you can check out on the product page.

If you have the ability to run under mod_perl (dedicated server) or using SpeedyCGI (especially for jump.cgi and search.cgi) then you can cut your resource usage way down, increase peformance, and develop a larger directory than possible with the flat file version.

Looked at another way, you need a machine this big [ - - ] to run the flat file version, but you need a machine this big [ - - - - ] to run the SQL version, but the machine big enough to run the SQL version will run a much, much larger directory -- possibly 10x or 50x larger than the flat file version, because of the improved code, but mostly because of the efficiency of an SQL/relational database written in optimized C/C++ to handle the file accesses :)





PUGDOGŪ Enterprises, Inc.
FAQ:http://LinkSQL.com/FAQ
Forum:http://LinkSQL.com/forum