[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