Slow query ?

[atarkowska]

I add pagination to the webclient but still the query seems to be 'slow'. Select was done on the dataset with 2440 images.
Slow means: start time: 2009-02-14 14:17:51.372902, end time: 2009-02-14 14:18:12.784592, or maybe 21sec is ok ;-)

import omero
import time
from omero.rtypes import *

ds_id = 56
page = 1

c = omero.client("mage", 4063)
c.createSession("jason", password)
#c.joinSession("08c9796e-6fa7-4d1b-9683-68d64fc6add0")
admin_serv = c.sf.getAdminService()
query_serv = c.sf.getQueryService()
cx = admin_serv.getEventContext()

p = omero.sys.Parameters()
p.map = {}
p.map["eid"] = rlong(cx.userId)
p.map["oid"] = rlong(ds_id)
if page is not None:
    f = omero.sys.Filter()
    f.limit = rint(24)
    f.offset = rint((int(page)-1)*24)
    p.theFilter = f

sql = "select im from Image im join fetch im.details.owner join fetch im.details.group " \
      "left outer join fetch im.datasetLinks dil left outer join fetch dil.parent d " \
      "where d.id = :oid and im.details.owner.id=:eid order by im.id asc"

print datetime.datetime.now()
print len(query_serv.findAllByQuery(sql,p))
print datetime.datetime.now()

c.sf.closeOnDestroy()

[atarkowska]

test - r3673

[jmoore]

In r3744 the test passed at under 1 second, Ola. Can you try to reproduce? Perhaps it was an artifact of all the connection silliness.

[atarkowska]

It seems to be pretty fast. THX