DynamoDBMapper负载与查询 [英] DynamoDBMapper load vs query

问题描述

DynamoDBMapper提供了从表中读取一项的不同方法:

The DynamoDBMapper provides different ways to read one item from a table:

• 查询
• 加载

是否有建议，可使用哪些?在快速测试中，以下两个代码段为主键为哈希且范围为键日期的表返回相同的"MyEntry"项目，而查询方法则快了约10％.

Is there a recommendation, which of them to use? In a quick test, the following two code snippets return the same "MyEntry" item for a table with primary key=hash and range key=date, whereas the query method is roughly 10% faster.

加载

public MyEntry getEntryForDay(final Integer hash, final LocalDate date) {
    return mapper.load(MyEntry.class, hash, date);
}

查询

public MyEntry getEntryForDay(final Integer hash, final LocalDate date) {
    final MyEntry hashKeyValues = new MyEntry ();
    hashKeyValues.setHash(hash);
    final Condition rangeKeyCondition = new Condition()//
            .withComparisonOperator(ComparisonOperator.EQ.toString())//
            .withAttributeValueList(new AttributeValue().withS(new LocalDateMarshaller().marshall(date)));
    final DynamoDBQueryExpression<MyEntry> queryExpression = new DynamoDBQueryExpression<MyEntry>()//
            .withHashKeyValues(hashKeyValues)//
            .withRangeKeyCondition("date", rangeKeyCondition)//
            .withLimit(1);
    final List<MyEntry> storedEntries = mapper
            .query(MyEntry.class, queryExpression);
    if (storedEntries.size() == 0) {
        return null;
    }
    return storedEntries.get(0);
}

推荐答案

好吧，现在随着我越来越习惯于使用DynamoDB，事实证明mapper.query代码中的错误导致了较差的性能:

Ok, now as I'm getting more used to work with DynamoDB it turns out that a bug in the mapper.query code is causing the poorer performance:

• 实际上，"withLimit(1)"并不限制列表中返回的总结果，而是将结果返回到"PaginatedQueryList"中，并且如果访问了实际项，则会从数据库中延迟加载它们. WithLimit(1)实际上限制了每个请求加载的项目.
• 实际的错误是"if(storedEntries.size()== 0)"部分，因为size()调用实际上加载了列表中的所有项目.使用withLimit(1)可能导致最差的性能.

映射器查询的正确代码是:

The correct code for the mapper query is:

public MyEntry getEntryForDay(final Integer hash, final LocalDate date) {
    final MyEntry hashKeyValues = new MyEntry ();
    hashKeyValues.setHash(hash);
    final Condition rangeKeyCondition = new Condition()//
            .withComparisonOperator(ComparisonOperator.EQ.toString())//
            .withAttributeValueList(new AttributeValue().withS(new LocalDateMarshaller().marshall(date)));
    final DynamoDBQueryExpression<MyEntry> queryExpression = new DynamoDBQueryExpression<MyEntry>()//
            .withHashKeyValues(hashKeyValues)//
            .withRangeKeyCondition("date", rangeKeyCondition)//
            .withLimit(1);
    final List<MyEntry> storedEntries = mapper
            .query(MyEntry.class, queryExpression);
    if (storedEntries.isEmpty()) {
        return null;
    }
    return storedEntries.get(0);
}

这篇关于DynamoDBMapper负载与查询的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！