ignite-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Ilya Kasnacheev <ilya.kasnach...@gmail.com>
Subject Re: Query execution too slow
Date Tue, 21 Aug 2018 15:59:10 GMT
Hello!

I think that value should have order of 1 to be used here. Can you try that?

Regards,

-- 
Ilya Kasnacheev

2018-08-21 18:56 GMT+03:00 Prasad Bhalerao <prasadbhalerao1983@gmail.com>:

> Original Sql query:
>
> SELECT dnsnb.value,
>   dnsnb.id
> FROM DnsNetBiosAssetGroupData dnsnb
> JOIN TABLE (value VARCHAR  = ? ) temp
> ON dnsnb.value             = temp.value
> WHERE dnsnb.subscriptionId = ?
> AND dnsnb.assetGroupId     = ?
> AND dnsnb.assetTypeInd     = ?
>
> temp table list has around 1_00_000 values.
>
> I also tried changing the indexes as follows. But it did not work.
>
> public class DnsNetBiosAssetGroupData implements Data<DefaultDataAffinityKey>,UpdatableData<DefaultDataAffinityKey>
{
>
>   @QuerySqlField
>   private long id;
>   @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "dns_nb_asset_group_data_idx1",
order = 1)})
>   private long assetGroupId;
>   @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "dns_nb_asset_group_data_idx1",
order = 2)})
>   private int assetTypeInd;
>   private int partitionId;
>   @QuerySqlField
>   private long subscriptionId;
>   @QuerySqlField
>   private long updatedDate;
>   //@QuerySqlField (index = true)
>   @QuerySqlField(orderedGroups = {@QuerySqlField.Group(name = "dns_nb_asset_group_data_idx1",
order = 3)})
>   private String value;
>
>
> Thanks,
> Prasad
>
> On Tue, Aug 21, 2018 at 7:35 PM ilya.kasnacheev <ilya.kasnacheev@gmail.com>
> wrote:
>
>> Hello!
>>
>> Can you please show the original query that you are running?
>>
>> Regards,
>>
>>
>>
>> --
>> Sent from: http://apache-ignite-users.70518.x6.nabble.com/
>>
>

Mime
View raw message