Out the door

lachoy on 2002-02-23T19:21:11

Latest SPOPS (0.57) with SQLite and Oracle support is whizzing around the world right now. I'm glad I waited until this morning, since Mr. Productivity updated DBD::SQLite to support the last_insert_rowid API call.

Something that could be kind of neat is enable OpenInteract to export chunks of itself for remote use. For instance, say we setup a bundle to run a standalone http daemon connecting to SQLite. It's not going to win any speed contests, but that's not its purpose. It's more along the lines of what Jon Udell talked about eons ago with the portable web application.


Speed contests

Matts on 2002-02-25T15:42:07

Actually it may just win speed contests.

Tatsu has been running performance tests. On updates it's about 70% of the speed of MySQL (latest release), but on selects it's faster. At least I think that's what he found.

The biggest problem now is the transaction model, which appears to prevent new connections when in a transaction. Very bad.