Hi Luca, Sorry, I was out. Let me try to put some dummy code as an example. Will be putting it shortly.
Thnx On Tue, Aug 22, 2017 at 6:08 AM, Rick Leir <rl...@leirtech.com> wrote: > 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 >
