search

greenlion / warp

WarpSQL Server, an open source OLAP focused distribution of the world's most popular open source database bundled with OLAP performance related plugins such as the WARP storage engine..
http://warpsql.blog
Other
41 stars 2 forks source link

Support UNIQUE_CHECKS = 0 #25

Closed greenlion closed 2 years ago

greenlion commented 4 years ago

To support faster loading of data, it should be possible to disable UNIQUE and PRIMARY KEY checking. Of course, this could allow duplicate data into tables, because WARP is not index organized and a UNIQUE/PRIMARY KEY is just a hint to check for duplicates at insertion/update time.

greenlion commented 4 years ago

removed index support in beta 2 - revisit later when indexes are added back in

greenlion commented 2 years ago

constraints are no longer supported in WARP at least for now.