Re: Query Accelerator - Web Applications

From: Richard Auslander <rich@airflash.com> > >This isn't strictly an Informix question, but I thought there'd be many >people here who had some direct Informix experience: > >We have a large-ish IDS/Solaris database, consisting of relatively few >tables which contain in excess of 12+ million records each. You can >consider the data to be similar to a personnel database, i.e., name, >address, city, state, zip, phone, etc. > >We are interested in delivering high-speed semi-freeform query access to >a web application, i.e., we need 100 - 200 millisecond-range performance >on queries that logically "AND" any combination of these properties >("where city = c and state = s and name contains (n) and zip = z"). In >addition, we may need some tokenized access to the name, so that I could >find "Robert Jones" if I only knew "R Jones", or could find "McDonald's >Restaurants" if I only had "McDonalds". > >I'm pretty aware of the kinds of parsing, tokenizing, and indexing I >could do with IDS 7.30, but don't believe it will deliver the kind of >performance we need.. > >Has anyone used any commerically-available query optimizers (such as >OMNIDEX that use optimized in-memory indexing, for example) or any other >search or search engine technology to provide these kinds of >capabilities? I would also offer that I am not familiar with Informix's >Advanced Decision Support or Parallel Query features. I'm not sure, but I think the text datablades can do this sort of thing. So if you upgraded to IIF.2000...? Onmidex *looks* good, but I've never seen it in use... ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com