[Developers] query timeouts

augusto callejas acallejas at appliedminds.com
Tue Mar 3 00:18:34 UTC 2009


hi-

i'm getting a consistent query timeout.
my query is for the /type/link history for /people/person nodes
that have been added since a certain time (and whose target
type's are from a certain set).

is there anything i can do to avoid the query timeout?
perhaps change the limit size when i cursor? will that
reduce the amount of time spent on the query?
or is query time based on other factors that are
query independent, but data size dependent?

thanks,
augusto.


----
{
   "q":{
     "code":"/api/status/error",
     "messages":[
       {
         "info":{
           "host":"graph04.p01.sjc1.metaweb.com",
           "detail":[
             "timed out"
           ],
           "timeout":8.0,
           "port":8100
         },
         "message":"Query timeout",
         "code":"/api/status/error/mql/timeout"
       }
     ]
   },
   "status":"200 OK",
   "code":"/api/status/ok",
   "transaction_id":"cache;cache01.p01.sjc1:8101;2009-03-03T00:10:14Z; 
0046"
}
====
{
   "q" : {
     "cursor" : "eNqVkNtOwzAMhl- 
nE6lmO47jWAjxHtUuSsukirJOHSAeH491FUjjAktRvvicv3ufT9NsvT5FayZLALvmYKhJY5JEu_bQ2x0qsxYUrteARavacbQboU01DoeX09v0o9Dm-qEaTq3BNS8mG-_rymf7qdeKGNcEsfmuEFCrHTAACONe4Zd13nU_fD73RmAoASVjYJEYMKesIHkBhQsgafD-DL7oAhoXKItHIH8DE5Xga5TCqhdIeAWmIAmoFCxnYEHR4Gu7IzokwSKUgqqmzJkDEpGz0satee0Ndjd1Gv_Q6WM4GmbICP9W6KzHOrM5zpPfW58oXIri9lEKIOK-Ky3571tEUH_zF_Lkfys=",
     "query" : [
       {
         "master_property" : null,
         "operation" : null,
         "sort" : "timestamp",
         "source" : {
           "guid" : null,
           "type|=" : [
             "/people/person"
           ]
         },
         "target" : {
           "guid" : null,
           "id" : null,
           "type" : [],
           "type|=" : [
             "/organization/organization",
             "/organization/organization_membership",
             "/tv/tv_actor",
             "/tv/regular_tv_appearance",
             "/tv/tv_program",
             "/people/person",
             "/film/actor",
             "/film/performance",
             "/film/film",
             "/music/album",
             "/music/artist",
             "/music/musical_group",
             "/music/group_membership",
             "/music/group_member",
             "/dining/restaurant",
             "/people/marriage",
             "/location/location",
             "/religion/religion",
             "/business/company",
             "/type/type"
           ]
         },
         "timestamp" : null,
         "timestamp>=" : "2009-02-28T04:33:59.275Z",
         "type" : "/type/link",
         "valid" : null
       }
     ]
   }
}
----


More information about the Developers mailing list