Yonatan Ben-Nes wrote: > Actually I even started to look on other solutions and maybe you can say > something about them also.. maybe they can help me: > 1. Omega (From the Xapian project) - http://www.xapian.org/ You could certainly do this with Xapian and Omega. With only 5 million records it should be very quick. The easiest approach would be to periodically dump the SQL tables and build a new Xapian index which reflects the SQL database - you'd probably want to customise the "dbi2omega" script in the Omega distribution. This approach works particularly well if the tables are updated in a batch fashion (one big weekly update, say). Alternatively you could hook into whatever updates the SQL database and get it to make corresponding updates to the Xapian index. That has the advantage that they'll always be in step, but is probably more work to set up. The main drawback compared to doing everything in SQL is that you'd have two systems to deal with rather than just one... Cheers, Olly ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
