SELECT CONCAT('tablename_', CAST(cp.id AS CHAR)) AS uniquekey,
cp.id,
cp.fieldname ..,
mp.fieldname,
mp. ....
FROM consumer AS cp
INNER JOIN morepush AS mp
ON cp.id = mp.id
in my "query" is a "norma" JOIN select.
-----
------------------------------- System ----------------------------------------
One Server, 12 GB RAM, 2 Solr Instances, 7 Cores,
1 Core with 31 Million Documents other Cores < 100.000
- Solr1 for Search-Requests - commit every Minute - 5GB Xmx
- Solr2 for Update-Request - delta every Minute - 4GB Xmx
--
View this message in context:
http://lucene.472066.n3.nabble.com/how-to-convert-YYYY-MM-DD-to-YYY-MM-DD-hh-mm-ss-DIH-tp2961481p2979311.html
Sent from the Solr - User mailing list archive at Nabble.com.
