brady.k — Tue, 01 May 2007 20:38:10 +0000

Yeah, but the whole point is that I want to write something myself, so not only do I learn something, I also get to have it do exactly what I want, and not waste any unnecessary resources.

swish-e

sherzodr — Tue, 01 May 2007 18:57:51 +0000

Yes, it is possible. You can use any of those free indexing tools. Check out swish-e! Using swish-e you can create an index of pretty much any data, be it in databases, static pages - you name it.

brady.k — Sat, 28 Apr 2007 04:02:05 +0000

Well, I guess the scale depends on the use...but it's intended to be massively big.

Is there a native way to run a search function (not a SELECT, but an actual ...search), within MySQL? That would save resources...

pr0gr4mm3r — Sat, 28 Apr 2007 03:33:27 +0000

I'm not sure that makes sense. A database is made to be searched through. A text file is not.

How large scale is this going to be? I run queries on tables that are 100MB in size of text with no problem.

brady.k — Sat, 28 Apr 2007 03:09:05 +0000

Well, I'm trying to minimize the database queries. I don't have access to memcache, so I have to watch database connections and things...I'm building a product made for large-scale usage.

The theory, at least in my mind, is that by access the entire database 4x a day, and the searching through that...it will actually make load times faster, because it doesn't have to have yet another mysql query being processed.

Does that make sense?

pr0gr4mm3r — Sat, 28 Apr 2007 01:42:23 +0000

What exactly is the search for. I don't know why you would want to save the database in a text file when a database is made to be queried with criteria.