C
C
chemax0072014-09-08 17:44:51
PHP
chemax007, 2014-09-08 17:44:51

Real Time indexes in Sphinx. How to work with linked tables?

Goodnight.
I've been struggling with real time indexes for a day now.
At the moment the project works on delta indexes. But I want faster updates.
I don't know what to do with the primary key, since more than 5 tables are linked to add in the query.
Generate random number? Sampling all the same goes on a heap of parameters.
Also, it is not possible to add an entry:

$connection = mysql_connect("127.0.0.1:9306") or die ("Couldn't connect to server.");
$db = mysql_query("INSERT INTO `rtIndex` (`id`, `Title`, `Description`) VALUES (1, '', '');", $connection);

Although through SSH the index can be filled. Through php even it is possible to search in this index.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander, 2014-09-08
@disc

Perhaps the problem is in quotes, run this query through the console

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question