[ReneG]

Quote:

Originally Posted by [HLF]Southclaw Also, Vincent is right, you can just save them all on one query (Though this might be a long line so you may have to do 2 or 3 separate lines and stick them together, or query them separately. I'm not sure which would be faster)

From what I've learned, formatting one large query would be much more efficient than updating each column in a separate query. Use a string counter and estimate to see how long the queries will be. I tend to stray away from queries that are longer than 1024 cells.


Question.

Is it efficient to free all queries that don't use the SELECT clause?

I've read somewhere you have to free results of all queries, and I also read in this tutorial that you're only supposed to free results that are returning data (SELECT clause).