Re: LOCK TABLES issue

2002-01-07 Thread Bob Sidebotham
someone let me know that, too?). Thanks, Bob Bob Sidebotham wrote: I have an application with fairly typical locking requirements: 99% of the requests are read-only (with an exception that I will specify). Update requests are relatively rare. There's a half-dozen tables, and since the inter

LOCK TABLES issue

2001-12-31 Thread Bob Sidebotham
way to do this, I'd appreciate it. Otherwise, is there any reaction to this proposal? Does anyone think this is useful functionality? Thanks, Bob Sidebotham - Before posting, please check: http://www.mysql.com/manual.php

Fulltext search with multiple document revisions

2001-12-15 Thread Bob Sidebotham
well with this: if a document has many revisions, then all the words in that document become (artificially) less relevant. Perhaps the boolean search facilities will overcome this difficulty in 4.0.1, I'm unclear on that. Can anyone suggest ways around this? Thanks, Bob Sidebotham

Re: Fulltext search with multiple document revisions

2001-12-15 Thread Bob Sidebotham
Hi! On Dec 15, Bob Sidebotham wrote: MySQL full text indexing looks attractive, but I'm puzzled as to how to use it for my application. I'm storing documents that I'd like to be full-text indexed, but each document can have multiple revisions. I'm currently storing each revision