CREATE TABLE with ENUM fields with large number of elements takes forever

Bug #589055 reported by Stewart Smith on 2010-06-03
6
This bug affects 1 person
Affects Status Importance Assigned to Milestone
Drizzle
Low
Stewart Smith
Dexter
Low
Stewart Smith

Bug Description

e.g. with 70,000 elements (probably indicative of 65535 performance) it takes 4min 20seconds on my laptop (Intel(R) Core(TM)2 Duo CPU P8600 @ 2.40GHz).

http://poormansprofiler.org/ shows it's all to do with check_duplicates_in_interval()

Related branches

Stewart Smith (stewart) on 2010-06-04
Changed in drizzle:
status: Confirmed → Fix Committed
Stewart Smith (stewart) on 2010-06-05
Changed in drizzle:
status: Fix Committed → Fix Released
To post a comment you must log in.
This report contains Public information  Edit
Everyone can see this information.

Other bug subscribers