Logical1 Posted May 25, 2009 Share Posted May 25, 2009 Which is more efficient? To organize data in smaller tables and give ID number to items but have to cross reference it later (in order to have to add a row of data in a table you need to pick up data from 4 different tables) or make one or two larger tables amd querry only one or two tables? The site I am working on may have a lot of visitors and I am concern about the number of SQL querries machine has to run simultaneously (or am I worried for nothing?) Thanks in advance L1 I have organized data in MySQL tables in a way that for one of my querries I have to get an Quote Link to comment https://forums.phpfreaks.com/topic/159518-which-method-would-be-more-efficient/ Share on other sites More sharing options...
kevinkorb Posted May 25, 2009 Share Posted May 25, 2009 Really it depends on how your data relates to each other. However following good database normalization techniques, and proper indexes is typcially the way to go. Quote Link to comment https://forums.phpfreaks.com/topic/159518-which-method-would-be-more-efficient/#findComment-841964 Share on other sites More sharing options...
fenway Posted June 1, 2009 Share Posted June 1, 2009 Far too little information... what's "data"? Quote Link to comment https://forums.phpfreaks.com/topic/159518-which-method-would-be-more-efficient/#findComment-846838 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.