[Typo3-typo3org] typo3.org - short time todos
wilhelm at icecrash.com
Fri Mar 18 18:49:14 CET 2005
> well, I don't know. if the data you write to the filesystem has to be
> transmitted over the local network to a common fileserver that could be as
> fast or slow as a proper SQL query, or am I wrong?
I think it will be faster - if you have a separate network for storage
reasons. Most of the software installed on webservers aren't optimized
for high traffic/high load purposes, but compiled to be good for the
general users, or is the mysql database not a standard deb/rpm/whatever?
If DBAL is quite useable, why not migrate the data to a PostgreSQL
database? It's a full featured database. Also you are able to program
functions on the database layer, setup views - an interesting point for
data fragmentation as the sql statements behind views are optimized and
stored persistant, while the query parser in mysql has to optimize the
query !every time the query was submitted!
If interested in, I have knowledge on PostgreSQL.
More information about the TYPO3-team-typo3org