Hi Django Users,
I'm using MySQL with Django but I dislike MySQL's default MyISAM
tables because there is no referential integrity. So I googled how to
force Django to create InnoDB tables with MySQL and I found that I
need to add this to my settings.py:
DATABASE_OPTIONS = {
"init_command": "SET storage_engine=INNODB",
}
I also saw that there was a comment stating to only do this when you
run syncdb and not when running in general. I can understand that
it's only really needed when you run the CREATE statements, but does
anyone know if it adds any overhead if it's left in? It's somewhat of
a PITA to have to remember to alter my settings if I'm adjusting my
data models.
Thanks,
Rob
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"Django users" group.
To post to this group, send email to django-users@googlegroups.com
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at
http://groups.google.com/group/django-users?hl=en
-~----------~----~----~----~------~----~------~--~---
