MySQL Forums
Forum List  »  Performance

Re: What is better? A large query? or too many short ones?
Posted by: Ariel Xarathos
Date: November 02, 2005 05:01AM

Well, the table is quite extense, but i figured out that i should group similar variables, e.g: i have 40 fields with strings like: "2-32-1", i access all of them from 1 to 40 with a loop. About 90 fields of the table are like that, maybe that caused my puny performance, looping around 90 fields reading, then looping 90 fields more to write, having in mind about 60 users loggin in (reading) and loggin out(writing) on the users table.
Thanks for the info though, i didnt know that sql updates the whole row just to update one field.
A thought: Maybe i should make all those 40 fields to 1 field with all the variables put together with separators, and access the database just once, and separate them by an algorythm in my server app.

By the way, sorry about my english, i havent used it in a while...

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: What is better? A large query? or too many short ones?
1231
November 02, 2005 05:01AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.