At 8:02 PM -0400 9/16/07, Mark Armendariz wrote:
Rob Marscher wrote:
On Sep 15, 2007, at 3:24 PM, Mark Armendariz wrote:
Anyways, that's my take on SQL and ORM. Both - with an easily
manipulated and portable meta language.
Sounds pretty cool. Ever thought of analyzing the queries used
within an application and automatically generate (or suggest)
indexes? Seems like your system might have self-analyzing
capabilities to be able to do that.
Working towards that as well. Currently has some basic profiling
capabilities for finding the real nasty queries (reminiscent to
adodb's). For the most part the multi-table queries tend to be
pretty tight as long as the indexes are already set up. I've been
considering what it would take to parse an explain and make
suggestions for some time.
The whole idea is something of a self-generating dao (or orm, i get
the concepts and then I get them mixed up) that quietly caches
itself out of existence over time, but sticks around for general
maintenance when needed. I'm glad to see some interest. Good
motivation to get this thing out in the world soon.
Mark
In regard to self-analyzing, it would be nice to have the option to
select what types of search methodologies the dB uses, such as splay.
Cheers,
tedd
--
-------
http://sperling.com http://ancientstones.com http://earthstones.com
_______________________________________________
New York PHP Community Talk Mailing List
http://lists.nyphp.org/mailman/listinfo/talk
NYPHPCon 2006 Presentations Online
http://www.nyphpcon.com
Show Your Participation in New York PHP
http://www.nyphp.org/show_participation.php
