On Thu, Mar 29, 2001 at 09:59:35AM +0100, Dominic Mitchell wrote:
> On Thu, Mar 29, 2001 at 08:56:36AM +0100, James Powell wrote:
> > Course, mysql does support transactions now... I believe with two
> > different types of table for some reason.
>
> It's because the underlying table type is implemented using Berkeley
> DB3, which does support transactions. And that has several modes of
> operation, hash, btree and recno.
>
> I haven't looked into it, but I would imagine that it makes transactions
> across different tables kind of tricky. In fact, I'd class it as a bit
> of a hack. But don't take my opinion for it, because this is all based
> on 2nd hand evidence.
>
> -Dom
But as well as Berkeley there's innobase and gemini (not in yet?)
table types that support transactions.
http://www.mysql.com/documentation/mysql/bychapter/manual_Table_types.html
I can't say I've used any of them or would trust any of them...
And MySQL has got full-text indexing now - didn't notice that one
http://www.mysql.com/news/article-54.html
"MySQL 3.23 now has full-text indexing and searching capabilities. This
allows you to search your vast databases of
textual information, with queries returning search string
occurrence/relevance."
Incidentally, saw your ssh letter in the new LJ...
jp
