• Post Reply Bookmark Topic Watch Topic
  • New Topic

AWS SDB - Execute select all query

 
Alex Monari
Greenhorn
Posts: 11
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Having read the AWS Simple DB documentation once again I've noted there's a maximum limit of 250 items returned items when executing a select query.

Currently for my java swing application for immediate population of my jtable I'm fine with this limit but I need to also select all the entries as part of my application's features whereby the user will prompt the display of all items.

Using a range query I intended on dealing with my challenge as follows:

Step 1: Obtain the latest entries based on the maximum returned results limit.

Step 2: Take content from the last row and 1st column which in my
case is date in the format YYYY:MMD and save this in a variable
e.g. startDate.

Step 3: Add 100 to step 2 above and save this in a variable eg.g
endDate.

Step 4: Use the values from step 2 and 3 as part of the range query
i.e.



Below is my current and fully functioning code which fetches the latest items based on the maximum returned results limit of 250



I appreciate any help.
 
  • Post Reply Bookmark Topic Watch Topic
  • New Topic
Boost this thread!