TRUNCATE TABLE replaced with DELETE FROM
abautu - February 17, 2007 - 22:22
| Project: | Drupal |
| Version: | 6.x-dev |
| Component: | base system |
| Category: | bug report |
| Priority: | normal |
| Assigned: | abautu |
| Status: | closed |
Jump to:
Description
Although TRUNCATE TABLE is faster (in MySql), I believe it is not a standard SQL command. I'm working on an SQLite layer. It is almost ready. I've noticed that cache.inc uses once the TRUNCATE TABLE command and I've replaced it with DELETE FROM.
Best wishes,
Andrei.
| Attachment | Size |
|---|---|
| cache_25.patch | 586 bytes |
#1
Please do not mark your own patches as 'ready to commit'.
However, this is true- http://dev.mysql.com/doc/refman/4.1/en/truncate.html
Committed to 5.
#2
Hi Andrei, committed this patch to CVS HEAD. Looking forward to your work. :)
#3