By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
444,136 Members | 2,135 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 444,136 IT Pros & Developers. It's quick & easy.

does query speed depend on the number of coloms?

P: n/a
Hi,

I was wandering.
Does the query speed also depend on the colums that you don't use in the
query (so not in the where and not in the select part).

I have a lange unused backup field in every row.
I only put the backup information into that field once.
But never use it on my live database.

Does it speed up my queries if I put the backup information into an other
table?

Thanks,
Wouter
Jul 20 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
"nospam_nopriva" wrote:
Hi,

I was wandering.
Does the query speed also depend on the colums that you don't
use in the
query (so not in the where and not in the select part).

I have a lange unused backup field in every row.
I only put the backup information into that field once.
But never use it on my live database.

Does it speed up my queries if I put the backup information
into an other
table?

Thanks,
Wouter


Donít think so. Of course, there is a bit of overhead to gather that
data, and send it to the client app... but it should be very small
compared to other things that bring the performance down.

I have found the main performance drag to be not having proper
indecis.

--
http://www.dbForumz.com/ This article was posted by author's request
Articles individually checked for conformance to usenet standards
Topic URL: http://www.dbForumz.com/mySQL-query-...ict167416.html
Visit Topic URL to contact author (reg. req'd). Report abuse: http://www.dbForumz.com/eform.php?p=561579
Jul 20 '05 #2

P: n/a
thanks!
:-)

Wouter

"steve" <Us************@dbForumz.com> wrote in message
news:41********@news.athenanews.com...
: "nospam_nopriva" wrote:
: > Hi,
: >
: > I was wandering.
: > Does the query speed also depend on the colums that you don't
: > use in the
: > query (so not in the where and not in the select part).
: >
: > I have a lange unused backup field in every row.
: > I only put the backup information into that field once.
: > But never use it on my live database.
: >
: > Does it speed up my queries if I put the backup information
: > into an other
: > table?
: >
: > Thanks,
: > Wouter
:
: Don't think so. Of course, there is a bit of overhead to gather that
: data, and send it to the client app... but it should be very small
: compared to other things that bring the performance down.
:
: I have found the main performance drag to be not having proper
: indecis.
:
: --
: http://www.dbForumz.com/ This article was posted by author's request
: Articles individually checked for conformance to usenet standards
: Topic URL:
http://www.dbForumz.com/mySQL-query-...ict167416.html
: Visit Topic URL to contact author (reg. req'd). Report abuse:
http://www.dbForumz.com/eform.php?p=561579
Jul 20 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.