Dan Libby wrote:
Hi Martin,
On Saturday 15 September 2007 15:01, Martin Kersten wrote:
Hi,
- Integrity checking is another major source of differences
Well, I am really only concerned with read performance. I wouldn't think integrity checking would come into play there...
Your primary key is an integrity constraint
The database complexity you measure is covered by (old) benchmarks like the Wisconsin and AS3AP benchmarks.
Are those published, with results for MonetDB and MySQL? I don't see them linked on the monetdb site.
In sql/src/benchmarks you find a serie.
Do you know if there is a document anywhere that discusses mysql to monetdb migration? I did see that monet can handle the mysql auto_increment keyword, which should be helpful.
MySQL/SQL is not standard compliant. MonetDB supports the SEQUENCE construct, i.e. auto-increment See website and SQL documentation.
A migration document does not exist. Would be helpful. But better is to find a tool in the open-source that can migrate between any database