[TYPO3-core] RFC #11023: Table sys_refindex cannot be created with DBAL

Michael Stucki michael at typo3.org
Mon Jul 6 17:51:01 CEST 2009


Hi Jigal,

Jigal van Hemert schrieb:
> Xavier Perseguers wrote:
>>>>>>> The syntax to specify only a given number of characters to be 
>>>>>>> taken for the index is MySQL-specific and furthermore is not 
>>>>>>> supported by t3lib_db parser making it impossible to create this 
>>>>>>> table for, e.g., Oracle from the Install Tool.
>>>>>>>
>>>>>>> Solution:
>>>>>>> Make an index with all 255 characters to be DBMS-agnostic:
>>>>>>>
>>>>>>> KEY lookup_string (ref_table,ref_string)
> 
> -1
> 
> It is best to keep indexes in MySQL as small as possible, especially if 
> the index uses multiple fields.
> Also if this is the primary key and this is a table that uses the InnoDB 
> engine this index will be part of the record itself instead of a 
> seperate index. A large primary key will make the data records much 
> larger than necessary.

Sorry to ignore your request, but it must be said that the key 
definition that was proposed by Xavier was already used at the 
beginning. It was only changed because of incompatibilities with the 
multiplyDBfieldSize feature, not because of any performance issues.

If we would really care for that and limit keys to a length that is most 
performant, someone would have to do it for every key to do it properly.

Regards, Michael
-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/


More information about the TYPO3-team-core mailing list