PicoraActiveRecord Coming!
Just ran a couple of (very) informal benchmarks on my local machine. These are averages.
INSERT
7100 per second - raw sql using mysql_query 3500 per second - Using PicoraActiveRecord
SELECT
66,000 rows to array per second 38,000 rows to PicoraActiveRecord object per second
These are wihtout an accellerator. Given my experience in the past I would not be surprised if the inserts went from 3500 to 5000, and the selects went from 38,000 to 50,000 once an accellerator is in place.
Regardless, I think it's safe to say that in the vast majority of situations that the database itself will become the pinch point long before Picora would.
Posted April 17th, 2007 at 4:01pm by ryan
Looks promising! Just out of curiosity: since picora is php5-only are you using pdo or does pdo just slow things down?
Posted April 21st, 2007 at 2:31pm by nolan
can´t wait for beta 4! hope "out before the end of the month" is still up to date :)
Posted April 29th, 2007 at 5:55am by RubenM
Wow! I can't wait... today is the end of the month =D
Posted April 30th, 2007 at 10:40am by chess64
Any day now... =D
Posted May 4th, 2007 at 11:25am by chess64
He didn't say WHICH month. ;-)
Posted May 5th, 2007 at 9:01am by jyeager
Still waiting .... :)
Posted May 15th, 2007 at 8:01am by Aaron
All this is really interesting ... I currently work on my own php framework too. Recently I replace all mysql_query to PDO and implemented some of the basic PDO functions for those who don't have PDO.
I'm interested in your implementation of ActiveRecord. Have you check to phpDoctrine? Really impressive for the speed, but heavy in memory usage.
Sorry for my english (I'm french)
Posted May 17th, 2007 at 7:24pm by philippe
What about the Beta 4 release? Still waiting ... :(
Posted May 28th, 2007 at 5:43pm by Aaron
how can i get a development snapshot from the svn?
Posted June 11th, 2007 at 11:16am by juliocarlos
Shit! The crowd gets restless!
Believe it (or not!) I am working on the download builder right now.
Lots o surprises. Hence the wait. Like everything in the last two months though, it'll be put out in a semi-unstable form, finalized a few weeks later and then publicized a few weeks after that. Don't expect any miracles in the next 48 hours in terms of reliability, but definitely expect them by 1.0.
This post intentionally does list a release date. Damn soon though...
Posted June 29th, 2007 at 6:13pm by ryan
Philippe, you can look at http://www.phpclasses.org/browse/package/2990.html The site requires registration to download, I can share zip if you wish.
Posted June 30th, 2007 at 3:11am by telega
Just wanted to let everyone know that Beta 4 will include a blazing fast ActiveRecord implementation that will work with SQLite and MySQL.
Like the Controller and View it doesn't do a lot of extra fancy stuff, but it makes working with databases a ton easier than hitting the raw PHP functions and is MUCH (much) faster than a lot of the current PHP AR implementations floating around.
Beta 4 is due out before the end of the month.
Posted April 17th, 2007 at 2:52pm by ryan