codeboost.com
Code Boost dot com: September 2012
http://www.codeboost.com/2012_09_01_archive.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Sunday, September 30, 2012. By default, when connected to MySQL server, every command is executed as a distinct transaction. As a result, after each INSERT SQL statement MYSQL saves data to the database and commits transaction. When your application inserts hundreds and thousands of records, your database is busy in saving new records all the time and you are loosing in speed. Query all new records are flushed and written to disk.
codeboost.com
Code Boost dot com: April 2013
http://www.codeboost.com/2013_04_01_archive.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Saturday, April 6, 2013. Speedup mysql index using ssd disk. You probably ask yourself sometimes how you can boost MySQL indexes when you are working with BIG databases/tables. If can be easily done. 1 You need to create a directory on your SSD disk that will be used for mysql indexes. In addition you need to give to mysql service write permission to that directory. Chown –R mysql:mysql /ssd/mysql-indexes. View my complete profile.
codeboost.com
Code Boost dot com: Speedup mysql inserts
http://www.codeboost.com/2012/09/speedup-mysql-inserts.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Sunday, September 30, 2012. By default, when connected to MySQL server, every command is executed as a distinct transaction. As a result, after each INSERT SQL statement MYSQL saves data to the database and commits transaction. When your application inserts hundreds and thousands of records, your database is busy in saving new records all the time and you are loosing in speed. Query all new records are flushed and written to disk.
codeboost.com
Code Boost dot com: October 2012
http://www.codeboost.com/2012_10_01_archive.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Thursday, October 4, 2012. 3 times speed increase with static pages. Internet was born from static pages. People were creating websites with emacs and vi. With increased popularity of scripting languages and open source databases like MySQL and Postgresql, more and more developers started to use these advanced tools. I would like to show you some benchmarks. Contents of test.html. Title hello world /title. Contents of test.php.
codeboost.com
Code Boost dot com: Optimize MySQL COUNT (*) query
http://www.codeboost.com/2013/02/optimize-mysql-count-query.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Monday, February 25, 2013. Optimize MySQL COUNT (*) query. There is not magic solution to count table contents especially if you have a client that has a table with 40 million records and you need to do the filtering using the 'OR' SQL statement. Original query was the following:. SELECT COUNT(*) from table1 WHERE field1 IN ('val1','val2') OR field2 IN ('val3','val4');. I created it as following:. As some of you know "OR. Now the ...
codeboost.com
Code Boost dot com: Hello World Post
http://www.codeboost.com/2012/09/hello-world-post.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Tuesday, September 25, 2012. This is my first post at this blog. Subscribe to: Post Comments (Atom). I am passionate about computers, networking, security, databases and especially application performance. I decided to create this blog to share my experience on building fast and quick software. View my complete profile. Micro optimization or why code runs slower on 64 b. Green Black Real Tea.
codeboost.com
Code Boost dot com: 3 times speed increase with static pages
http://www.codeboost.com/2012/10/static-pages-3-times-speed-increase.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Thursday, October 4, 2012. 3 times speed increase with static pages. Internet was born from static pages. People were creating websites with emacs and vi. With increased popularity of scripting languages and open source databases like MySQL and Postgresql, more and more developers started to use these advanced tools. I would like to show you some benchmarks. Contents of test.html. Title hello world /title. Contents of test.php.
codeboost.com
Code Boost dot com: Speedup mysql index using ssd disk
http://www.codeboost.com/2013/04/speedup-mysql-index-using-ssd-disk.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Saturday, April 6, 2013. Speedup mysql index using ssd disk. You probably ask yourself sometimes how you can boost MySQL indexes when you are working with BIG databases/tables. If can be easily done. 1 You need to create a directory on your SSD disk that will be used for mysql indexes. In addition you need to give to mysql service write permission to that directory. Chown –R mysql:mysql /ssd/mysql-indexes. April 6, 2013 at 7:47 PM.
codeboost.com
Code Boost dot com: February 2013
http://www.codeboost.com/2013_02_01_archive.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Monday, February 25, 2013. Optimize MySQL COUNT (*) query. There is not magic solution to count table contents especially if you have a client that has a table with 40 million records and you need to do the filtering using the 'OR' SQL statement. Original query was the following:. SELECT COUNT(*) from table1 WHERE field1 IN ('val1','val2') OR field2 IN ('val3','val4');. I created it as following:. As some of you know "OR. Now the ...
codeboost.com
Code Boost dot com: Micro optimization or why code runs slower on 64 bit
http://www.codeboost.com/2012/09/why-code-runs-slower-on-64-bit-processor.html
Code Boost dot com. Code optimization tips and tricks, stuff that matters. Thursday, September 27, 2012. Micro optimization or why code runs slower on 64 bit. One of my friends works for the company doing video processing. He told me that the company code runs slowly on 64 bit processor than on 32. It can be number of reasons. I would like to talk about the most important one. The main problem is the size of the integer. So, when you have the following code:. Unsigned char * data = new char[n];. When cod...
