A big project in EZ??

Next topic

Author	Message
Natu Lauchande	Friday 07 October 2005 11:27:25 am Hi I am about to start, a project of an relatively large size development project: -An web based information system , with a very big database , with an integration with a geografical information system for displyaying maps(ArcGis) with statistical information. I have been evaluating some PHP based plattforms, i would like to know if there's anything that large, made with EZ and if you have any other sugestion of plattform. Thank in advance Muna
Frederik Holljen	Saturday 08 October 2005 12:56:29 am Can you say a bit more about exactly how large your site is going to be? How do you want to store your data, how much data, what kind of queries (and how) do you want to run. How many hits / searches etc. And of course, what kind of hardware are you planning to use?
Natu Lauchande	Sunday 09 October 2005 1:06:04 am Hi It will have a database with something like, 1000 fields.It will work as a data repository of some statistical data .With more or less 100 geographicaly distributed users that gathers data and puts it on the system.The user's are supposed do have some restrictions to update information(different views) and some structured categorized queries. I would like to know if it is possible and adequate (development time and perfomance) to use ezpublish as a development framework to this project or if there is any other suited php based alternative. Thanks in Advance.
Gabriel Ambuehl	Sunday 09 October 2005 1:36:47 am It seems to me that this demands a custom backend. 1000 fields in one table? That's gonna take some serious machinery behind the scenes to work with 100 users (especially if they are running compley queries against the DB)! Depending on the amount of data, you're even way into the DB warehousing arena. Seeing that statistics is a lot of number crunching this is true even more so. You'll want to use a heavy metal RDBMS (Postgre might cut it, MySQL probably won't) and software written for the purpose. Ezpublish is very flexible but with flexibility comes a price: here it's lots and lots of DB entries which would likely slow it down a LOT. Visit http://triligon.org
Lazaro Ferreira	Sunday 09 October 2005 4:58:42 pm Hi Natu, When you say 100 users, you are talking of 100 concurrent users ? (i.e : 100 users updating information simultaneously, in less than a minute ) I have read in this forum of ezp sites actually dealing with more than 50 concurrent users Regarding tables with 1000 fields , it has little to do with EZP itself. MySQL limit is far above this value , you can get more info at mysql site. I think that having a 1000 fields table, doesn't mean necessarily dealing with particulary slow queries to database Regarding a php suite to develop your application, It depends on what kind of functionality you will need for your application , ezpublish is above all an enterprise level content management system, which can be extended in php to develop other kind of web applications, but having in mind that content management and related applications are ezpublish main advantage Lazaro http://www.mzbusiness.com
Natu Lauchande	Sunday 09 October 2005 8:39:30 pm Hi Lazaro, Thanks for your helpful hints.I realized that the 100 users are actually not concurent. I'll be evaluating ez-publish for a while to see if it fits to the needs.