|
| Version History |
 |
|
|
|
November 24th, 2005 - 2:15 PM - By Ven
sorry, had to show a quick benchmark. all of coa is now on InnoDB, except 1 table, which is HEAP. I am going to try to convert more tables over to HEAP, but this data is never 'saved' it is there, but once mysql is shutdown or restarted, the data go poof. So sessions and various other crap, it helps a lot.
anyways, here is the benchmarks, I just did a simple test. To be fair, after changing the table each time, I took ran the test 5 times, i didn't count the first 2, and I took the average of the other 3.
MyISAM : 2000 Queries : 3.31942 Seconds
HEAP : 2000 Queries : 0.47977 Seconds
InnoDB : 2000 Queries : 1.82107 Seconds
November 24th, 2005 - 1:42 PM - By Ven
Experimenting with a few different table types in mysql.. I just discovered HEAP.. which is very interesting I have to admit. I haven't benchmarked it, but, i guess I should :) but then again.. just the fact that the current users page uses 1 table, and that table is now stores in RAM, and the data on a peak day does not go over like.. 500K, I think it rocks. though there are limitations, but I've adjusted the table accordingly.
November 23rd, 2005 - 5:26 AM - By Ven
I went ahead and made modifications to the database server's configuration. I then proceeded to go and change the table type to InnoDB instead of MyISAM. I think it is a smart move. in some testing benchmarks (with over 123,000 rows), there was a 4 second speed difference. I was fair and did the benchmark 5 times with both types. The test was a complexed task.
So I converted all 149 tables and it went smoothly.. restarted the webserver, and I don't know if it was just me or not, but I noticed an awesome and noticable speed difference
November 14th, 2005 - 3:13 PM - By Ven
Minor changes to account edit and to the readmail code. Added crap to stop certain events from constantly happening. Sometime in the future people will grow up, maybe.
Various changes to the merchandise page as well as the IPN system for paypal. woot.
November 7th, 2005 - 7:33 PM - By Ven
Changed the spam filter's internal from 5 minutes to 2 minutes (due to a corinary that emerged today).
October 28th, 2005 - 8:46 PM - By Ven
Well.. I added code to offer people free 7 day memberships. The code is still alive on the site for non-paid's to get the 48 hour trial membership.. but, I decided there should be a way for me to just pick random people and give them 7 days to try it out.
Worked over 16 hours yesterday, Im vegging today.
October 27th, 2005 - 11:37 AM - By Ven
Various template work.. Most of the time was spent using m$ office to setup a weird format mail merge.
Added [age] age to the Bios, so users can have their age inserted automatically and won't have to change it everyyear. example "Hi, My name is Ven, I am [age], have pity on me"
October 25th, 2005 - 3:46 AM - By Ven
Started working on the onlinestore a little more. I decided I want the orders to start going into an online processing system.. but I only have the DB setup at the moment.. Not sure how I will proceed from there. Time will tell.
October 25th, 2005 - 3:45 AM - By Ven
i changed the collective slightly.. I wanted to add the option for people to 'okay' the use of their image, for the onlinestore.. Eventually the plan is (once there are enough images).. to link the images to store codes (id's) and eventually have rotating images on the store. or an optional gallery.
October 19th, 2005 - 1:22 AM - By Ven
Fixed various aspects of the redirection engine that I was not pleased with.. standardized the code between the various error handling documents. Much better.. Want to improve more but will need a few days.
|
|
|
|
