|Syntactic Confectionery Delight|
Re: Perl/CGI Performanceby ajt (Prior)
|on Jul 30, 2002 at 08:30 UTC||Need Help??|
You have several things mixed up, and I think it's best to separate them out.
Returning to your questions. CGI/Perl is not the fastest way of doing things, but it's pretty good for low to medium volumes. If you have written the code well, it can probably be converted from CGI to mod_Perl, in which case it will run much faster.
There are many advantages of using a DB for storing data, and it should be easy to export data using Perl into any simple output fromat. Proper database systems have all the advantages of file-locking, multi-user capability, and potentially higher speeds. Examples include: MySQL, PostgreSQL or even DBD::SQLite all should be easy to use from Perl.
A basic Linux/Apache/Perl box with a 1GHz+ processor and 1Gb RAM, will run very quickly, and be adequate for most needs, but cost more than USD15/month. You may find that at your suggested price range your options are more limited.
One word of caution, you say you are a novice, in which case I would urge extreme caution if you are going to be moving money about. Web security is easy to get wrong, and you may be better off using code that someone else has written, and has been scrutinised by the public in general. I don't claim to know of such software.
Additional links to read: