Luca, Did you say _slower_ mySQL? It is blazing fast, I used it with over 10m records and no appreciable latency. The underlying InnoDB is excellent. Design your schema using mySQLworkbench. Cheers -- Rick
On August 22, 2017 2:16:07 AM EDT, Luca Dall'Osto <tenacious...@yahoo.it.INVALID> wrote: >Hello, >thank you for your responses. >Ok, therefore I have to archive this problem with no appropriate >solution in Solr, and try to do it with a relation-based DB such as >mySQL or Postgres. >Build the custom sort function could be a valid solution instead of use >the slower mySQL or try Postgres (I never used Postgres) or I have to >forgot it? >Thanks! > > >Luca > > >On Saturday, August 19, 2017 1:02 AM, Rick Leir <rl...@leirtech.com> >wrote: > > > Luca >Walter has got the best word on this, you should use SQL for sorting >(maybe mySQL or Postgres). If you also need searching, you can create a >Solr index by ingesting from the SQL database. The Solr index would be >just used for searching. Cheers -- Rick >-- >Sorry for being brief. Alternate email is rickleir at yahoo dot com > > -- Sorry for being brief. Alternate email is rickleir at yahoo dot com
