#1
  1. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    22
    Rep Power
    0

    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.

    Thanks
  2. #2
  3. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    22
    Rep Power
    0
    I've resolved this now as I wasn't connecting in the right way to the db in my perl
    script:

    DBI:mysql:question_searchwords_rt;host=127.0.0.1;port=9306

    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.
  4. #3
  5. No Profile Picture
    Registered User
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2013
    Posts
    22
    Rep Power
    0
    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?

IMN logo majestic logo threadwatch logo seochat tools logo