Tag: mysql
Why don't Silverstripe CMS queries run in MySQL?
When debugging an ORM call, you may find yourself collecting the SQL that will be exectued via the DataList::sql() function - this is great, but when copied and pasted into e.g.
Read more about 'Why don't Silverstripe CMS queries run in MySQL?'...
Read more about 'Why don't Silverstripe CMS queries run in MySQL?'...
Fixing MySQL 5.7 troubles easily
Many hosters are now updating their machines to use MySQL 5.7. A minor update doesn't sound that bad, unfortunately one small change in MySQL's default config can cause major headaches...
Read more about 'Fixing MySQL 5.7 troubles easily'...
Read more about 'Fixing MySQL 5.7 troubles easily'...
Speeding Up MySQL (instead of using sqlite)
Many people use sqlite for testing purposes because it's fast... and it's fast because it uses memory for many operations instead of the disk...
Read more about 'Speeding Up MySQL (instead of using sqlite)'...
Read more about 'Speeding Up MySQL (instead of using sqlite)'...
How to speed up unit tests using sqlite
Running unit tests might be dead slow if you're using mysql for it, cause for every test a new DB is set up and destroyed afterwards.
Read more about 'How to speed up unit tests using sqlite'...
Read more about 'How to speed up unit tests using sqlite'...