DesignersTalk - View Single Post

Hunch · 06-05-2008, 11:14

I'm not sure how either of the restructuring (breaking into multiple columns/tables) would help you either given that you're still going to have the same number of entirely distinct fields.

If you're considering doing it in code, rather than through the database, and efficiency is your goal, I'd perhaps start thinking about other alternatives to PHP. My first port of call would probably be C++ simply because it's pretty renowned for speed. Just out of interest, I banged a few keywords into Google to see if anyone had any benchmarks, and found this quite informative page. The results are conclusive (although probably to be expected) with the C++ CGI version being up to 70 times faster than PHP on occasions. Notice on the really large tests, only C++ can even handle that volume of data. PHP and ASP both wimp out.

WrenSoft - Zoom Search Engine - Benchmarking PHP vs ASP vs Javascript vs CGI

06-05-2008, 11:14	#12 (permalink)
Hunch Grumpy old man Join Date: Oct 2007 Location: North Japan Posts: 1,375	I'm not sure how either of the restructuring (breaking into multiple columns/tables) would help you either given that you're still going to have the same number of entirely distinct fields. If you're considering doing it in code, rather than through the database, and efficiency is your goal, I'd perhaps start thinking about other alternatives to PHP. My first port of call would probably be C++ simply because it's pretty renowned for speed. Just out of interest, I banged a few keywords into Google to see if anyone had any benchmarks, and found this quite informative page. The results are conclusive (although probably to be expected) with the C++ CGI version being up to 70 times faster than PHP on occasions. Notice on the really large tests, only C++ can even handle that volume of data. PHP and ASP both wimp out. WrenSoft - Zoom Search Engine - Benchmarking PHP vs ASP vs Javascript vs CGI