Forums / Suggestions / txtSQL

txtSQL

Author Message

Faraz Ali

Sunday 02 January 2005 12:49:15 pm

This might have been mentioned before somewhere on the forums, but I can't seem to be able to locate it...

I would reccommend using txtSQL in your eZ CMS program. There are several reasons for this...
- txtSQL offers speed uncomparable by other flatfiles systems
- Reliability and security of files
- Use of functions in queries
- Can be used on any system using PHP
- SQL syntax is being developed
- The revision and editing of data is simple through txtSQLAdmin
- Released under the GPL
- Advanced error reporting
- Enables easy linking of rows in several tables
- and much more

txtSQL is located at http://txtsql.sf.net

Thank you for your time,
Faraz Ali

Björn Dieding@xrow.de

Sunday 02 January 2005 4:04:22 pm

Hey,
I don't think eZ will ever run on a flatfile system at a reasonable speed.

If you think thta your product can beat convertional databases please provide a benchmark.

Looking for a new job? http://www.xrow.com/xrow-GmbH/Jobs
Looking for hosting? http://hostingezpublish.com
-----------------------------------------------------------------------------
GMT +01:00 Hannover, Germany
Web: http://www.xrow.com/

Ekkehard Dörre

Monday 03 January 2005 7:35:34 am

Look here:

http://txtsql.sourceforge.net/index.php?newsid=18&c=1
FarazAli wrote there:
<i>
The reason that I didn\'t use a txt-forum is because of the simple fact that a compiled program (postgresql) will always execute quicker than an interpreted one.
</i>

Greetings, ekke

http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com
CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

Faraz Ali

Monday 03 January 2005 3:44:24 pm

oops, I thought it was flatfile the whole time... sorry

Ekkehard Dörre

Tuesday 04 January 2005 5:27:27 am

a flatfile based wcms is
http://phpcms.de/index.en.html

I like it very much, but I used only webgrab and the search spider. More perhaps in future :-)

Greetings, ekke

http://www.coolscreen.de - Over 40 years of certified eZ Publish know-how: http://www.cjw-network.com
CJW Newsletter: http://projects.ez.no/cjw_newsletter - http://cjw-network.com/en/ez-publ...w-newsletter-multi-channel-marketing

eZ debug

Timing: Jan 30 2025 21:19:55
Script start
Timing: Jan 30 2025 21:19:55
Module start 'content'
Timing: Jan 30 2025 21:19:55
Module end 'content'
Timing: Jan 30 2025 21:19:55
Script end

Main resources:

Total runtime0.0294 sec
Peak memory usage6,144.0000 KB
Database Queries4

Timing points:

CheckpointStart (sec)Duration (sec)Memory at start (KB)Memory used (KB)
Script start 0.00000.0086 587.7422370.3203
Module start 'content' 0.00860.0133 958.06251,005.4453
Module end 'content' 0.02200.0074 1,963.507874.7031
Script end 0.0293  2,038.2109 

Time accumulators:

 Accumulator Duration (sec) Duration (%) Count Average (sec)
Ini load
Load cache0.00258.6664120.0002
Check MTime0.00103.5273120.0001
Mysql Total
Database connection0.00062.209210.0006
Mysqli_queries0.003010.161340.0007
Looping result0.00000.092520.0000
Template Total0.006923.610.0069
Template load0.00082.586610.0008
Template processing0.006221.010110.0062
Override
Cache load0.00051.824510.0005
General
dbfile0.003511.9006100.0003
String conversion0.00000.016230.0000
Note: percentages do not add up to 100% because some accumulators overlap

Templates used to render the page:

UsageRequested templateTemplateTemplate loadedEditOverride
1pagelayout.tpl<No override>extension/sevenx/design/simple/templates/pagelayout.tplEdit templateOverride template
 Number of times templates used: 1
 Number of unique templates used: 1

Time used to render debug report: 0.0001 secs