Jaime Teng wrote: > Hi, > > I am in the process of planning a huge project. > It will be web based with heavy database accesses. > > Since I am have more programming experience with Perl, > I prefer using it. However several people have suggested > using PHP + MySQL + Apache combo. > > If you are given the choice, what will you choose? > > a) MySQL + Perl + modPerl + Apache + Linux > or > b) MySQL + PHP + Apache + Linux > > I hope you could give me some of the insights I dont know > about the two in terms of program efficiency as well as > "maintainability".
Depending on what else you need to learn, acquiring a new language can be enough of a learning curve to delay the whole project. I tend toward perl as I haven't found anything it won't do for me, but YMMV. How wedded are you MySQL ? I personally would use it only for situations where there was a single user connecting at a time (or at most only a few) and data integrity is not important. MySQL lacks too many features of a reliable database for me to trust it. Our company has found PostgreSQL <http://www.postgresql.org/> to be functional. It has much better transactional integrity and with some tuning scales a lot better than MySQL as the number of simultaneous users increases. It also has some nifty extensions (tsearch2, postGIS, etc.) which seem to be more robust than their MysSQL equivalents. It does a window distro which I have only used for prototyping; we use linux and solaris for real applications. If you do go for postgres you should be sure to read about tuning it and tweak the configuration it is distributed with, which is very conservative and made to run on a minimalist configuration. Best of Luck (and you should probably also ask on a PHP list for alternate opinions), Greg Williamson BDA GlobeXplorer LLC _______________________________________________ Perl-Win32-Users mailing list Perl-Win32-Users@listserv.ActiveState.com To unsubscribe: http://listserv.ActiveState.com/mailman/mysubs
