• Registered: 2006-01-20
  • Posts: 18

Topic: Unbuffered/buffered query

I've modified my forum to hide the edited message when the edit was performed before any subsequent posts were made in the topic, but in the process, I needed to edit the big post-fetching query in viewtopic to be buffered rather than unbuffered so the inner post-searching query wouldn't terminate the outer one. Everything seems to work fine, but I was wondering if there's anything I should watch out for, like if buffered queries make servers catch fire or something. I don't know much about the advantages or disadvantages of query buffering.

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: Unbuffered/buffered query

No, the only advantage with an unbuffered query is that it is a little bit more conservative with the memory on the server. Nothing to worry about.

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website