Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>I have done benchmarking for Indexing Times for Sphinx &amp; Solr. Sphinx is far ahead as compared to Solr with respect to Indexing Algorithms (super fast indexing times and small index size). </p> <p>When you say 10 pages of text, it seems <strong>you even dont need Real Time Sphinx Indexing</strong>. You can follow the main + delta indexing scheme in Sphinx (you can find that on Sphinx Documentation). It would be superfast and near real time. If you want more help on this please feel free to ask, would be glad to explain you.</p> <p>Solr is great but when it comes to optimized Algorithms Sphinx rocks!! Try Sphinx.</p> <p>Coming to your questions in the comment, Solr/Lucene supports incremental indexing (known as delta imports in their terminology) and its quiet easy to configure however they are pretty slow as compared to the method used by Sphinx.</p> <p>Main+Delta is quick enough because what you can do is create a temporary table store you new text in that and index that. According to the documentation:Sphinx supports "live" (almost real time) index updates and it could be implemented using so called "main+delta" scheme. The idea is to set up two sources and two indexes, with one "main" index for the data, and one "delta" for the new documents. </p> <p>Say for example you have 10 Million records so you can keep that as the main index and all the new documents get added to a new table which will act as the delta. This new table can be indexed from time to time (say every 1hr) and the data gets searchable within very few seconds as you have 10 pages of text. Now after your new records are being searched you can merge the documents of the main table + delta table which can be carried out without interfering your search. When the documents are merged, empty the new table and again after an hour you can carry out the whole process again. I hope you got that else please feel free to ask any question.</p>
    singulars
    1. This table or related slice is empty.
    1. POSearch large amounts of constantly updated text in mysql
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USYavar
    1. USYavar
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POSearch large amounts of constantly updated text in mysql
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    1. COThank you for your help. From what i read main+delta is exactly what i need. But there's one point that's not clear in the doc; they say it wil reduce the indexing time down to 30 to 60 sec. In my case it is critical to have new text ready to be searched within seconds (max a minute). Is main+delta quick enough? From what I see Sphinx is that way to go.
      singulars
      1. PO
      1. USapplechief
    2. COYou are most welcome. You can see my edited answer above. Main+Delta should work great for you because Sphinx indexing is really really fast. However one more thing: Please also have a look at the real time indexes in Sphinx as mentioned in one of the answers above, I have never used it but it seems promising. After applying both to your data you can check what works best for you.
      singulars
      1. PO
      1. USYavar
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload