Forums

artoodetoo

Member

From: Far-Far-Away

Registered: 2008-05-11

Posts: 206

Unbuffered queries

Excuse my English. I wonder why FluxBB uses mysql_unbuffered_query in many places.

I've not found any place where fetching loop terminates before all queried rows have been retrieved. Unbuffered query loop is longer than buffered one. So, table locks for a long time.

The single cause of unbuffered query is memory. But is it so critical? For example in viewtopic: 25 posts-per-page * max. 65536 bytes of message text = 1.5M of memory. Is it TOO BIG? Other web engines (MVC-compliant) fetches all data before rendering of view.

In topic loop we cannot call other query, it follow the error. For ex., we can rebuild NO cache "on the fly".

If you have a voice for unbuffered query, clear it for me, please!

Last edited by artoodetoo (2010-01-10 08:29:06)

---

Russian FluxBB Community | "Elektra" mods for v1.2 on PunRes

qie

Member

Registered: 2008-06-02

Posts: 376

Re: Unbuffered queries

yes, although i'm not sure what the mysql_unbuffered_query handles, but FluxBB using too much memory is definetly true to me as I ever used it in some hosts. there the admin told me that, your forum 's cpu usage now normal but the memory usage is too large,so my account was been suspended.

since i have removed all modifications I didn't know what to do with that,

then the temp solution is " I closed the permission of Guest view",that means the forum threads and posts only are visible by members who log in.

now i still experienced this problem.thanks for sharing any idea with this issue.

Last edited by qie (2010-01-10 12:47:12)

---

now show:光宇游戏

zaher

Member

From: Damascus, Syria

Registered: 2008-07-12

Posts: 118

Website

Re: Unbuffered queries

FirebirdSQL is always unbufferd for that i prefer it over mysql or postgre,
But I am not sure about sqlite.