On 8/22/06 6:08 PM, "John Osborne" <[EMAIL PROTECTED]> wrote:
> Daryl Richter wrote: >> My production Instiki has about 2K rows in pages + revisions and my "All >> Pages" does take about 10 seconds. I do have Postgres on the backend rather >> than MySQL. >> >> I did notice that "All Pages" seems slower in 0.11 (db version) than 0.10, >> but given the sparse information available, I don't really know what it >> could be. >> >> > Thanks Daryl, I was poking around a bit and ran into this: > http://blog.zmok.net/articles/2006/08/14/full-text-search-in-ruby-on-rails > > Right now I'm running mysql on the backend (I gave up on Postgres and my > mysql issues went away when I switched from 3.23 to 5) and assuming > Instiki is doing a full text search using mysql that could be our > problem. I don't know if there are any plans to add Ferret to Instiki...? Not that I know of, though I (and John Whitley) have been (very slowly) trying to start working on the Instiki code base. Am I correct in thinking that your problem was fixed by adding a MySQL full-text index? > > -John > > -- Daryl http://itsallsemantics.com "2 + 2 = 5, for sufficiently large values of 2." -- Ron Jeffries _______________________________________________ Instiki-users mailing list [email protected] http://rubyforge.org/mailman/listinfo/instiki-users
