August 18th, 2013, 08:37 AM
Sphinx realtime index inserts
I'm using Perl DBI and Sphinx.
I have a realtime index set up and my understanding from reading around is that I should be able to insert into the (index name as table to insert to?)
However, it doesn't think the table exists so I'm not quite sure if I've misunderstood how this works.
Does anyone know, the documentation on this seems quite limited.
August 18th, 2013, 02:45 PM
I've resolved this now as I wasn't connecting in the right way to the db in my perl
I also had to shut down server, delete the generated rt sphinx files and start it up
again to pick up the rt column names I had added.
August 18th, 2013, 02:47 PM
I've also realised that to query a realtime index it must be done via SQL rather than using the Sphinx search Perl module.
However, I don't know how to match by multiple terms and rank in order of occurrence, is it just standard MySQL way? I'm concerned a realtime index might even be slower and I need this to be very fast as it's a keypress event.
Any advice on the best approach?