NYCPHP Meetup

[tedd]

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