monkeytooth Posted September 30, 2008 Share Posted September 30, 2008 I am a bit confused.. what is the differences one needs to think about when building a DB that is expected to have a high volume of usage. Like I can go to any generic tutorial and learn how to use a DB code it to work with a site, and even have many parts of the site driven off of it.. but what is it that those tutorials aren't teaching that makes a difference from what they teach and what you would need? and that said where is a good reference to learn from that can help one learn how to code sites and databases alike that will be high usage? Link to comment https://forums.phpfreaks.com/topic/126385-mysql-coding-for-preformance/ Share on other sites More sharing options...
discomatt Posted September 30, 2008 Share Posted September 30, 2008 Learn how the engine works. That's your best bet Link to comment https://forums.phpfreaks.com/topic/126385-mysql-coding-for-preformance/#findComment-653549 Share on other sites More sharing options...
monkeytooth Posted September 30, 2008 Author Share Posted September 30, 2008 learn it how though? is there something in specific I should look for in the aspect of how it works or just generally how a search engine works? Also know any good articles anywhere on the subject? Link to comment https://forums.phpfreaks.com/topic/126385-mysql-coding-for-preformance/#findComment-653551 Share on other sites More sharing options...
discomatt Posted September 30, 2008 Share Posted September 30, 2008 http://dev.mysql.com/tech-resources/articles/why-data-modeling.html That's a start. The dev zone @ MySQL's site is a good place to start. Link to comment https://forums.phpfreaks.com/topic/126385-mysql-coding-for-preformance/#findComment-653553 Share on other sites More sharing options...
discomatt Posted September 30, 2008 Share Posted September 30, 2008 Anther great resource ( goes with PHP too ) is teh user contrib notes in the manual. Tons of little hints when trying to optimize a certain function to perform efficiently Link to comment https://forums.phpfreaks.com/topic/126385-mysql-coding-for-preformance/#findComment-653555 Share on other sites More sharing options...
DarkWater Posted September 30, 2008 Share Posted September 30, 2008 learn it how though? is there something in specific I should look for in the aspect of how it works or just generally how a search engine works? Also know any good articles anywhere on the subject? Not a search engine, but the internal MySQL engine. Kind of like when Regex users say that you should learn how the Engine works, and they mean the regex engine. Link to comment https://forums.phpfreaks.com/topic/126385-mysql-coding-for-preformance/#findComment-653557 Share on other sites More sharing options...
redarrow Posted September 30, 2008 Share Posted September 30, 2008 Just get a dedecated database server or build one...... dont try and invent a database use mysql it free........... ur be there for years took 300.000 members to get mysql tested write........ Link to comment https://forums.phpfreaks.com/topic/126385-mysql-coding-for-preformance/#findComment-653662 Share on other sites More sharing options...
DarkWater Posted September 30, 2008 Share Posted September 30, 2008 Just get a dedecated database server or build one...... dont try and invent a database use mysql it free........... ur be there for years took 300.000 members to get mysql tested write........ He's not even talking about creating a new database engine. Are you reading the same topic as the rest of us? =/ Link to comment https://forums.phpfreaks.com/topic/126385-mysql-coding-for-preformance/#findComment-654093 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.