acidglitter Posted May 23, 2008 Share Posted May 23, 2008 so i have a large member table right now with maybe 18 different fields, and only around 5 of them are being used often. would it be better to keep it that way, and continue using SELECT specific, field, name (instead of SELECT *) or would it be better to have 2 tables, one with the most often used info and the other one with more specific info thats not selected as often? Link to comment https://forums.phpfreaks.com/topic/107017-which-way-is-better/ Share on other sites More sharing options...
Barand Posted May 24, 2008 Share Posted May 24, 2008 it's better to use SELECT specific, field, name (instead of SELECT *) unless you really do need every column. What is the table structure? Link to comment https://forums.phpfreaks.com/topic/107017-which-way-is-better/#findComment-548623 Share on other sites More sharing options...
acidglitter Posted May 24, 2008 Author Share Posted May 24, 2008 just like member_id name picture member points those show up on almost every page, then more specific details that are mostly only visible to the member like date joined last login referrals most of the fields are just the int/bigint or varchar types Link to comment https://forums.phpfreaks.com/topic/107017-which-way-is-better/#findComment-548633 Share on other sites More sharing options...
acidglitter Posted May 26, 2008 Author Share Posted May 26, 2008 ?? Link to comment https://forums.phpfreaks.com/topic/107017-which-way-is-better/#findComment-550000 Share on other sites More sharing options...
fenway Posted May 29, 2008 Share Posted May 29, 2008 It's useful to separate data vertically if there are TEXT/BLOB fields that are rarely used, or the main table is read often, updated rarely... this will improve query cache performance. Link to comment https://forums.phpfreaks.com/topic/107017-which-way-is-better/#findComment-552681 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.