@Jan
are you using sqlite?
mic
2012/6/4 Massimo Di Pierro <massimo.dipie...@gmail.com>:
> I do not know what may be causing it, except that:
>
> - one ajax/json call is better than many
> - each call will lock the session for the use which means they are not
> executed concurrently, they are queued, unless you
> session._unlock(response).
>
>
>
> On Monday, 4 June 2012 11:02:23 UTC-5, Jan Rozhon wrote:
>>
>> Hi Massimo,
>>
>> thank you for your answer. Unfortunately, it didnt help. One thing I
>> didn't mention and might be causing this trouble is, that I ask for several
>> json values provided by similar controllers as I posted in my first post.
>> Can the multitude ofjson requests cause this weird behaviour? In other
>> words, is it better to provide several small json streams or one large?
>>
>> Thanks in advance, Jan
>>
>> Dne pondělí, 4. června 2012 17:38:41 UTC+2 Massimo Di Pierro napsal(a):
>>>
>>> Try replace output=rows with output=rows.as_list()
>>> Perhaps the rows are not json serializable.
>>>
>>> On Monday, 4 June 2012 02:20:39 UTC-5, Jan Rozhon wrote:
>>>>
>>>> Hi group, I have encountered a problem when I try to call a controller
>>>> which should return a JSON array of values from database. However in abou 1
>>>> of 5 cases this call stucks in "loading" phase (chrome animation in tab)
>>>> and
>>>> no response is received. Data is in database, every other controller is
>>>> working fine, cpu utilization is pretty low so is the memory and there are
>>>> only about 10000 rows in DB. Could you please give me some hints?
>>>>
>>>> Thanks, Jan
>>>>
>>>> PS. The controller looks like this:
>>>>
>>>> def dberrorsselect():
>>>> """Performs sql query to get the errors in the form of list of dicts
>>>> such as {field_name:value}. This is then transformed to json dict for
>>>> transfer."""
>>>> if session.tb_id:
>>>>
>>>> max_id=tb(tb.errors.test_id==session.tb_id).select(tb.errors.id.max()).first()[tb.errors.id.max()]
>>>> if max_id != None:
>>>> selector_id=int(max_id)-5
>>>> else:
>>>> selector_id=0
>>>> rows=tb((tb.errors.test_id==session.tb_id)&(tb.errors.id >
>>>> selector_id)).select(tb.errors.ts, tb.errors.msg_short, tb.errors.msg_long)
>>>> output=rows
>>>> else:
>>>> output=[]
>>>> return dict(output=output)
>>>>
>>>>
>
