I do like blogspot except for few things :

No categories, I’m familiar with label in gmail but not label in blogspot beta
No timestamp modification, I do try to use “future posting” but it’s show as immediately in blogspot not waiting for right moment.
Performancing can’t upload image with blogspot beta.

Click here to continue reading..

“Have good SQL query standards”
Gee, seem easy to say but often difficult to deploy.

Many people tend to use abstraction layer like adodb, pear, ezsql etc . They have coding convention and good manual.
Portable SQL will lead on good application, seamless integration with other DB.
How about You?

Click here to continue reading..

“Use benchmarking”
Yes, big hit to database with not optimized configuration will make disaster and stress.

Click here to continue reading..

“increase temp table size in a data warehousing environment (default is 32Mb) so it doesn’t write to disk (also constrained by max_heap_table_size, default 16Mb)”
Data working faster in memory process not in disk write mode.
Nowadays many linux livecd distro created to gain that benefit, more memory more speed
in windows try to find this value [...]

Click here to continue reading..