I have looked for threads that have discussed what the purpose of the "sequence" table is in a mysql environment but havent been able to find any which was really surprising. I'd think this issue would be a hot topic. I've had multiple problems when importing things as nodes into a drupal DB such as a bunch of text articles and every time I always have to update the sequence table with whatever ID auto_increment gives me. Since mysql keeps track of the ID's, isnt this a pretty redundant table and un-needed? I dont know about other DB types, maybe they dont do auto-increment tracking, but what DB wouldnt? To me this seems like a completely un-necessary step and should be completely ripped out or at least turned off if the DB engine being used is mysql.
Posted by LanceLight on