Hi Chris, > I think it would make no semantic difference, but would increase MySQL > performance with these table types, if the primary key listed > stamp_inserted first instead of last.
The change you propose, as you say, would not be impacting - but would you have any testing handy which confirms the hint? Another option to get a monotonically increasing key is to set a synthetic index, ie. a spare field defined as AUTO_INCREMENT, which needs to be complemented by some indexes of choice in order to be effective. I've recently spared some time to write this page on the wiki: http://wiki.pmacct.net/CustomizingTheSqlIndexes Comments? Perhaps an idea is to contribute the "Implementation Notes" section of the wiki with other takes on those topics (or new topics)? Cheers, Paolo _______________________________________________ pmacct-discussion mailing list http://www.pmacct.net/#mailinglists
