[TYPO3-core] RFC: improving index of sys_template

[Karsten Dambekalns]

Hi.

I looked up a few things, here we go.

On 13.10.2006, at 11:54, Dmitry Dulepov wrote:

> Karsten Dambekalns wrote:
>> Support for table types is there already, I implemented it a while  
>> back.
>> Correct me if that was only for DBAL. :)

The regular install stuff detects and uses the table type if given in  
a dump.

> So, if they are there, may be can declare some tables as InnoDB? This
> will really improve performance. Especially for cache_* and sys_stat.

Yes, you can assign the types. No detection for the supported storage  
engines is done in TYPO3, but the MySQL manual says:

"If you try to use a storage engine that is not compiled in or that  
is compiled in but deactivated, MySQL instead creates a table using  
the default storage engine. ... This automatic substitution of the  
default storage engine for unavailable engines can be confusing for  
new MySQL users. In MySQL 4.1, a warning is generated when a storage  
engine is automatically changed."

So besides maybe producing a warning - which will never be fetched  
into anything - this will always work.

Regards,
Karsten
-- 
Karsten Dambekalns
Gimme Five!
http://typo3.org/gimmefive


-------------- next part --------------
A non-text attachment was scrubbed...
Name: PGP.sig
Type: application/pgp-signature
Size: 304 bytes
Desc: This is a digitally signed message part
Url : http://lists.netfielders.de/pipermail/typo3-team-core/attachments/20061014/4520fb22/attachment.pgp