date:20160504

how to range search on the field which contains multiple decimal point (eg: 2.5.0.4)

2016-05-04 Thread Santhosh Sheshasayanan


Hi,

I have issue in my server. As I stated in the subject I want to do range search 
query on the field (eg: filed name is "version") which contains value like 
(2.5.0.1, 2.5.0.4 and 2.5.0.10 etc).

When I do range search on the "version" field with criteria [* TO 2.5.0.5], it 
gave me all the value like (2.5.0.1, 2.5.0.10, 2.5.0.4). But this is wrong 
result. Since I was expecting only 2.5.0.1 and 2.5.0.4.
But it include 2.5.0.10 with the results. I googled and found that solr does 
lexical sorting. But I want numerical sorting. I declared the field type as 
string in schema.xml.

I did the following solution but nothing worked.

* Converted the field type to number. But it gave me 
"NumberFormatException".  Because java does not allow multiple decimal point.

* I added left pad 0 with the value while adding document in solr. But 
no luck

Can you please give me good solution to come out of the issue?


Regards,
Santhosh S




Disclaimer:  This message and the information contained herein is proprietary 
and confidential and subject to the Tech Mahindra policy statement, you may 
review the policy at http://www.techmahindra.com/Disclaimer.html externally 
http://tim.techmahindra.com/tim/disclaimer.html internally within TechMahindra.

Advice to add additional non-related fields to a collection or create a subset of it?

2016-05-04 Thread Derek Poh

We have a "product" collection and a "supplier" collection.
The "product" collection contains products information and "supplier"
collection contains the product's suppliers information.
We have a subsidiary page that query on "product" collection for the
search. The display result include product and supplier information.
This page will query the "product" collection to get the matching
product records.
From this query a list of the matching product's supplier id is
extracted and used in a filter query against the "supplier" collection
to get the necessary supplier's information.

The loading of this page is very slow, it leads to timeout at times as
well. Beside looking at tweaking the codes of the page we are also
looking at what tweaking can be done on solr side. Reducing the number
of queries generated bythis page was one of the optionto try.

The main "product" collection is also use by our site main search page
and other subsidiary pages as well. So the query load on it is substantial.

It has about 6.5 million documents and index size of 38-39 GB.
It is setup as 1 shard with 5 replicas. Each replica is on it's own
server. Total of 5 servers.
There are other smaller collections with similar 1 shard 5 replicas
setup residing on these servers as well.

I am thinking of either
1. Index supplier information into the "product" collection.
2. Create another similar "product" collection for this page to use.
This collection will have lesser product fields and will include the
required supplier fields. But the number of documents in it will be the
same as the main "product" collection. The index size will be smallerthough.

With either 2 options we do not need to query "supplier" collection. So
there is one less query and hopefully it will improve the performance of
this page.

What is the advise between the 2 options?
Any other advice or options?

Derek

--
CONFIDENTIALITY NOTICE

This e-mail (including any attachments) may contain confidential and/or privileged information. If you are not the intended recipient or have received this e-mail in error, please inform the sender immediately and delete this e-mail (including any attachments) from your computer, and you must not use, disclose to anyone else or copy this e-mail (including any attachments), whether in whole or in part.

50 matches

Mail list logo