Re: Discussion: Mysql Db Performance

2009-02-09 Thread David E Jones
The most important thing I know about performance is that until you know with proof from tests you're just guessing, and even with lots of experience acting on a guess can hurt as much as help. In fact, ask anyone with a lot of profiling experience and they'll know based on lots of wrong

Discussion: Mysql Db Performance

2009-02-09 Thread madppiper
Hey everyone, while taking a closer look at the fieldtypemysql.xml file i noticed that we are using predominantly varchars, which got me thinking. I know out of my own experience (and from several authors), that the use of dynamic datatypes results in increased query times. A well formatted datab