Let's optimize mysql for big database.

[reaby]

The default values of mysql configs are not optimal for big database usage... here's some tips to optimize the thoughtput of mysql for biiiiiiiig databases

key_buffer_size to 512mb, default is 16mb so with a 102mb database it is going to do lot's of read in the hard disk for keys,

same for sort_buffer_size that is also used during grouping, if the result it tries to group sort doesen't fit in the default 512kb it will do write/reads on the hardisk to do it. Try to put 16mb instead of the few default few KB.

increase also read_buffer_size to I don't know a few MB's. 32mb should be fine, here the idea is the results that are stored of one single query.

Basically, first the search is done on keys, ideally all the keys of a database needs to be in the ram. Then if all results are filtered well enough. it will get the data and put it in the read buffer and send it. The issue is if you try don't have enought ram it will again need to do writes and reads.

Among these lines, you might also find mysql documentation a useful read.
This should make of widgets appearing on server after map change quite fast (+ update at dev)