Yikes.  Guess I'll need to go back to the SQL search I had designed.  Wasn't
as pretty, but a whole lot faster.

Thanks.
  -----Original Message-----
  From: Barney Boisvert [mailto:[EMAIL PROTECTED]
  Sent: Monday, December 01, 2003 8:09 PM
  To: CF-Talk
  Subject: RE: Update Verity Collections Execution Time

  Yeah.  Verity is slow.  We had a collection (designed by a developer before
  my time, I might add) with about 10,000 items in it.  Inserting a new row
  took upwards of 45 seconds on a reasonably beefy machine (dual P-III 666).
  As you might imagine, that quickly got scrapped in favor of the very speedy
  FULLTEXT search from MySQL.

  Cheers,
  barneyb

  > -----Original Message-----
  > From: Andy Ousterhout [mailto:[EMAIL PROTECTED]
  > Sent: Monday, December 01, 2003 6:02 PM
  > To: CF-Talk
  > Subject: Update Verity Collections Execution Time
  >
  > Does it sound correct that adding a single record to a verity
  > collection thru
  > action = ''My Goodness Cookies
  > www.omygoodness.com
  > 910 Sherwood Drive, Unit 19
  > Lake Bluff, IL    60044
  >
  > Phone 847.735.9890
  > Fax     847.735.9910
  > Yahoo IM:  andy_ousterhout
  >
  >
  >
[Todays Threads] [This Message] [Subscription] [Fast Unsubscribe] [User Settings]

Reply via email to