11,000 html pages searchable
11,000 html pages searchable
Out of context: Reply #16
- Started
- Last post
- 17 Responses
- acescence0
searching aside, I think you should definitely put the content into some sort of db. whether or not you're doing the searching yourself, I think it would simplify things.
as far as search is concerned, mysql is definitely not optimized for fulltext search, but it's certainly capable to a degree. to put things in perspective, I worked on a production db that was up to 30 million rows and a lot of text. fulltext searches would take up to 20 seconds on a properly indexed db, but that's with a dataset maybe 2000 times larger than what you're dealing with. anyway, if you the whole index doesn't fit in ram, you're still dealing with the overhead of going to disk no matter what means of local search you use.
anyway, I would just use google.