Mysql container \"another type table\"

[daviddu54]

hi

i have tried mysql container by kerphy,but it dont work ,then i have build another mysql and it work

Code: Select all

  var $_db = null;
  var $_sql_create_table = "
 ";

u need just to collapse this table on the old table in mysql.class.php
::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::::
Salut

j'ai essayer le container mysql de kerphy ,mais j'ai eu nombre d'erreur tel que "la clé est trop grande" ou ce genre de table n'accepte pas les données blob/text".

tout ce que vous avez a faire c'est de collez la rable ci dessus a la place de l'autre dans le fichier mysql.class.php

[mikez]

I would not recommend using a MyISAM table with the mysql container. MyISAM is a hard disk-based storage type, and you will gain no benefit over using a flat file storage container. The original mysql container contributed here uses a MEMORY, or HEAP storage type which writes to memory and is very fast.

The problem is, many web hosting plans will only allow MyISAM table types. They will claim that other types (such as InnoDB) tend to create excessive overhead. If you are not able to create MEMORY or HEAP tables, I would suggest sticking to the shared memory or flat file storage containers.

Mike

[daviddu54]

Hi mikez

I know that ,this method is only for people who have no another choice ,no chmod or no heap and memory mysql table and this is my case