Talk in English - US at Longhorn PHP Conference 2018
Track Name:
Balcones
View Slides: https://www.dropbox.com/s/wpsuo5sj8fv03g8/Prepared-v07.pdf?dl=0
Short URL: https://joind.in/talk/2b853
(QR-Code (opens in new window))
With high-volume data wrangling, it pays to remember the fundamentals with PHP prepared statements. We walk through my benchmark showing techniques leading to 10X performance improvements. Meanwhile, when MySQL tables quickly grow by millions of rows, table storage space becomes an issue. Our table design must focus on keeping these tables compact and efficient. Here, too, prepared statements simplify both coding and table design. This talk uses CakePHP 3’s excellent support for PHP prepared statements, but all concepts are native to PHP and apply to any project striking this use case.
Comments
Comments are closed.
Ed explains very well and is very knowledgeable.
Good coverage of how to improve the speed of getting data into a database using prepared statements and/or bulk inserts.
Speaker had good knowledge of the topic and was able to address questions and comments. I really liked his lecturing/speaker style.