I guess that is the confusing part - when using create db I'd expect the database to last until I drop it (or the server ist stoppend in this case)
If we extend MAINMEM to write main-memory databases to disk, this would indeed mean that all databases created via db:create will get persistent.
I would give it a try (account request sent)
Confirmed!
I am not sure what wou mean with ignoring full-text, queries with "containing text ..." seem to work (at least in my tests)
Full-text expressions will continue to work, but they won't be sped up by the full-text index anymore. In many cases, this may not be a real bottleneck, however, because main-memory access if faster anyway.
I can think of supporting the development of such functionality if you consider worth the effort
Thanks for the offer.. Anyone else interested in supporting this feature?
Considering the current penalty with calling optimize() after every change and otherwise (at least for me) no big differences in usage this would make an interesting use case
When it comes to optimize(), you could play around with the UPDINDEX option.
Christian