开发者

Performance difference between 1 query returning n records and n queries returning 1 record?

开发者 https://www.devze.com 2023-04-04 14:37 出处:网络
With respect to Amazon SimpleDB, Is there any significant performance difference between select * from mydomain where itemName() in(\'id1\',\'id2\',\'id3\', \'id4\')

With respect to Amazon SimpleDB,

Is there any significant performance difference between

select * from mydomain where itemName() in('id1','id2','id3', 'id4')

and

select * from mydomain where itemName() == 'id1'
select * from mydomain where itemName() == 'id2'
select * from mydomain where itemName() == 'id3'
select * from mydo开发者_JAVA技巧main where itemName() == 'id4'


Starting four whole new queries might be slower than running one which is only a little bit more slower compared to any of the other four.

0

精彩评论

暂无评论...
验证码 换一张
取 消

关注公众号