lucene-solr-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Howe, David" <David.H...@auspost.com.au>
Subject RE: Index size increases disproportionately to size of added field when indexed=false
Date Mon, 19 Feb 2018 02:23:30 GMT

Hi Erick & Alessandro,

I have solved my problem by re-ordering the data in the SQL query.  I don't know why it works
but it does.  I can consistently re-produce the problem without changing anything else except
the database table.  As our Solr build is scripted and we always build a new Solr server from
scratch, I'm pretty confident that the defaults haven't changed between test runs as when
we create the Solr index, Solr doesn't know what order the data in the database table is in.

I did try removing the geo location field to see if that made a difference, and it didn't.

Due to project commitments, I don't have any time to investigate this further at the moment.
 When/if things quiet down I may see if I can reproduce the problem with a smaller number
of records loaded from a flat file to make it easier to share a project that shows the problem
occurring.

Thanks again for all of your assistance and suggestions.

Regards,

David

David Howe
Java Domain Architect
Postal Systems
Level 16, 111 Bourke Street Melbourne VIC 3000

T  0391067904

M  0424036591

E  David.Howe@auspost.com.au

W  auspost.com.au
W  startrack.com.au

Australia Post is committed to providing our customers with excellent service. If we can assist
you in any way please telephone 13 13 18 or visit our website.

The information contained in this email communication may be proprietary, confidential or
legally professionally privileged. It is intended exclusively for the individual or entity
to which it is addressed. You should only read, disclose, re-transmit, copy, distribute, act
in reliance on or commercialise the information if you are authorised to do so. Australia
Post does not represent, warrant or guarantee that the integrity of this email communication
has been maintained nor that the communication is free of errors, virus or interference.

If you are not the addressee or intended recipient please notify us by replying direct to
the sender and then destroy any electronic or paper copy of this message. Any views expressed
in this email communication are taken to be those of the individual sender, except where the
sender specifically attributes those views to Australia Post and is authorised to do so.

Please consider the environment before printing this email.
Mime
View raw message