#3979 BLOC First D: Datastore performance sucks

[Zarro Boogs per Child]

#3979: Datastore performance sucks
------------------------+---------------------------------------------------
  Reporter:  marco      |       Owner:  bcsaller              
      Type:  defect     |      Status:  new                   
  Priority:  blocker    |   Milestone:  First Deployment, V1.0
 Component:  datastore  |     Version:                        
Resolution:             |    Keywords:  relnote               
  Verified:  0          |  
------------------------+---------------------------------------------------

Comment(by marco):

 Results with id caching (on my box):

 Returned 611 results (limited to 30) in 4.08384895325 seconds
 Returned 611 results (limited to 30) in 2.09611201286 seconds
 Returned 611 results (limited to 30) in 4.45734882355 seconds
 Returned 611 results (limited to 30) in 1.99316310883 seconds
 Returned 611 results (limited to 30) in 4.19605088234 seconds
 Returned 611 results (limited to 30) in 2.0003619194 seconds
 Returned 611 results (limited to 30) in 4.42568993568 seconds
 Returned 611 results (limited to 30) in 2.0493221283 seconds
 Returned 611 results (limited to 30) in 5.09592485428 seconds
 Returned 611 results (limited to 30) in 2.30330181122 seconds
 Returned 611 results (limited to 30) in 4.25927495956 seconds
 Returned 611 results (limited to 30) in 2.07789897919 seconds

 If I'm not missing something and we actually can cache the id in
 ProcessedDocument that sounds like something we might want to do for
 trial-3.

-- 
Ticket URL: <https://dev.laptop.org/ticket/3979#comment:10>
One Laptop Per Child <https://dev.laptop.org>
OLPC bug tracking system