From: Andrew H. <ah...@di...> - 2002-03-28 22:03:45
|
Hi All, Yep, I have one of those unanswerable questions. General thoughts much appreciated. I'm looking at Webware as a tool to prototype a portal. There will be a database behind it, probably PostgreSQL (since MySQL is not free for commercial use) and I also wish to record every page hit (URL unique id, from page, to page) so we can track how users use the site. Therefore, row level locking is required. Basically, I'm looking for a tool that lets me quickly build a few different site styles so we can put in front of the users and get some feedback, and then quickly hack it around. I am familar with Python, but not a guru. The other challenge is that this prototype has to run on Solaris and Windows 2000. (More of a database issue I think.) Any thoughts/comments? Thanks. Regards Andrew Hallam Digital Earth Pty Ltd http://www.digitalearth.com.au |
From: Chuck E. <ChuckEsterbrook@StockAlerts.com> - 2002-03-29 06:23:48
|
On Thursday 28 March 2002 02:00 pm, Andrew Hallam wrote: > Hi All, > > Yep, I have one of those unanswerable questions. General thoughts > much appreciated. > > I'm looking at Webware as a tool to prototype a portal. There will be > a database behind it, probably PostgreSQL (since MySQL is not free > for commercial use) and I also wish to record every page hit (URL > unique id, from page, to page) so we can track how users use the > site. Therefore, row level locking is required. > > Basically, I'm looking for a tool that lets me quickly build a few > different site styles so we can put in front of the users and get > some feedback, and then quickly hack it around. I am familar with > Python, but not a guru. > > The other challenge is that this prototype has to run on Solaris and > Windows 2000. (More of a database issue I think.) > > Any thoughts/comments? Thanks. Keep in mind that your web server and app server don't have to be on the same box as the database. If your site gets hit hard you might need a separate box anyway, just for speed. But Webware runs on both *nix and Windows anyway. For tracking traffic you might simply use your web server's log unless you have an explicit reason not to. I use Apache and Webware and get nice performance. Since the WebKit app server caches the servlets, you get an automatic speed benefit for using them and also the ability to cache whatever results you like, however you like. I would crank out your prototype and worry about performance later. Most of my performance issues have come from external processes like data feeds and databases. Most of what was left after that was solved by simple caching. Finally, I made a few optimizations to MiddleKit recently. -Chuck |
From: Geoffrey T. <gta...@at...> - 2002-03-29 13:34:50
|
On Friday March 29, 2002 01:23 am, Chuck Esterbrook wrote: > I would crank out your prototype and worry about performance later. > Most of my performance issues have come from external processes like > data feeds and databases. Most of what was left after that was solved > by simple caching. Finally, I made a few optimizations to MiddleKit > recently. I would second that. In my experience the database has _always_ been the performance bottleneck. Webware has never posed a performance problem. And I agree, simple caching is both easy to implement in Python and very effective in reducing the load on the db. - Geoff |
From: Clark C . E. <cc...@cl...> - 2002-03-30 04:00:47
|
On Fri, Mar 29, 2002 at 09:00:01AM +1100, Andrew Hallam wrote: | I'm looking at Webware as a tool to prototype a portal. There will be a | database behind it, probably PostgreSQL Webware+Python+PostgreSQL+Apache on FreeBSD is very stable and fast. I've had MySQL crap out on me enough not to trust it with anything but a report database that can be re-constructed from a real data store like PostgreSQL. Also PostgreSQL now has python stored procedures for real back-end intensive operations. | The other challenge is that this prototype has to run on Solaris and | Windows 2000. (More of a database issue I think.) PostgreSQL requires a GPL'd library on Windoz, so this will work for prototypes but not for production unless you are GPL. The above combination on Win2K with cygwin (using the non-cygwin Python) works acceptably on a laptop computer... but it runs about 10x slower on the same hardware as compared to FreeBSD. | Any thoughts/comments? Thanks. I wouldn't give it a moments thought... plough ahead as it is smooth sailing. Best, Clark |