Suchy Posted June 6, 2007 Share Posted June 6, 2007 In my db I have a table with couple of varchars (limited to 100 characters), 3 ints (limited to 15 chars) and 2 text fields. These fields are for information for photos uploaded to my site (ex. link to it, where it was taken, date, camera model...) I have a page that lists all of them and some of the info. So does it matter if I use a quere that selects everything, or should I select only what is being used. Because I did not notice any difference in performence or speed. Quote Link to comment Share on other sites More sharing options...
btherl Posted June 6, 2007 Share Posted June 6, 2007 It probably won't affect the speed to fetch data from disk, as the entire record will be in a single page. But it may affect the speed to send data over the network (if you are doing that). And if you have a large result set, you will notice that more. If the mysql server is on the same machine as your script, you probably won't notice much difference. Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.