ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Sergi Vladykin <sergi.vlady...@gmail.com>
Subject Re: Sort queries are slow
Date Tue, 04 Apr 2017 11:15:44 GMT
Alexey,

Definitely! Please go ahead.

Anil,

If you do not use indexes, then sorting will be performed each time. Sorry.

>From your pattern I suspect that you output the result set into some UI
table with sortable columns, am I right?

Sergi

2017-04-04 13:54 GMT+03:00 Anil <anilklce@gmail.com>:

> Hi Sergi,
>
> Thanks for the response.
>
> I have around 70 columns and support sorting on many columns. group index
> is not suitable in my case. Do you have any other suggestions ?
>
> To some extent https://issues.apache.org/jira/browse/IGNITE-3013 improves
> the response time.
>
> Thanks
>
>
> On 4 April 2017 at 15:28, Sergi Vladykin <sergi.vladykin@gmail.com> wrote:
>
>> You should create a group index on (A, B) and rewrite the query the
>> following way:
>>
>> select * from Test where A = '<something>'  order by A, B
>>
>> Semantically it will be the same, but it will use index (A, B) for search
>> and sorting.
>>
>> Sergi
>>
>> 2017-04-04 12:18 GMT+03:00 Anil <anilklce@gmail.com>:
>>
>>> HI,
>>>
>>> i have created a table with columns A and B. A is indexed column. and
>>> use following queries
>>>
>>> 1. select * from Test where A = '<something>'
>>> 2. select * from Test where A = '<something>'  order by B
>>>
>>> #1 is fast as it uses default sorting of indexed column A. But #2 is
>>> slow.
>>>
>>> Do you think creating index on B will speed up #2 query ? i tried that
>>> as well and no luck.
>>>
>>> are there any ways to improve the performance of #2 ? please advise.
>>>
>>> Thanks
>>>
>>>
>>
>

Mime
View raw message