Forums / Developer / A big project in EZ??

A big project in EZ??

«

Previous topic

|

|

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.

eZ debug

Timing:	Jan 20 2025 16:53:32
Script start
Timing:	Jan 20 2025 16:53:32
Module start 'content'
Timing:	Jan 20 2025 16:53:32
Module end 'content'
Timing:	Jan 20 2025 16:53:32
Script end

Main resources:

Total runtime	0.0239 sec
Peak memory usage	2,048.0000 KB
Database Queries	4

Timing points:

Checkpoint	Start (sec)	Duration (sec)	Memory at start (KB)	Memory used (KB)
Script start	0.0000	0.0092	587.8125	180.8438
Module start 'content'	0.0092	0.0064	768.6563	97.8359
Module end 'content'	0.0155	0.0083	866.4922	74.7031
Script end	0.0238		941.1953

Time accumulators:

Accumulator	Duration (sec)	Duration (%)	Count	Average (sec)
Ini load
Load cache	0.0026	11.0386	12	0.0002
Check MTime	0.0014	5.8034	12	0.0001
Mysql Total
Database connection	0.0009	3.7805	1	0.0009
Mysqli_queries	0.0039	16.1790	4	0.0010
Looping result	0.0000	0.1246	2	0.0000
Template Total	0.0078	32.6	1	0.0078
Template load	0.0007	3.0607	1	0.0007
Template processing	0.0070	29.4727	1	0.0070
Override
Cache load	0.0005	2.0657	1	0.0005
General
dbfile	0.0043	17.9606	10	0.0004
String conversion	0.0000	0.0299	3	0.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

Usage	Requested template	Template	Template loaded	Edit	Override
1	pagelayout.tpl	<No override>	extension/sevenx/design/simple/templates/pagelayout.tpl
Number of times templates used: 1 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs