what about performance

This is really very good class.
I want to know about the performance issues?
I just print_r some of the objects and found a lot of information in those objects.

Can this create a problem in speed?

some more points...

1) multiple OR in condition
2) Group By ?
3) what about mysql functions like MAX(), DISTINCT(), AVG() ?


Thanks

i really dont think speed will be affected by objects size.if you have worked in drupal or someting like that,they have really huge objects.

The result is stored in an array for iteration ,So if your result is really huge,there might be a problem.But that can be fixed..

I have added support for MAX(),MIN() GROUP BY etc recently.Please download the latest version of the class.Also download the howto.html which decsribes the usage of these new features...below i am adding the section that explains the usage for Mysql functions


To find the max,min.sum or average value for a column in rowset ,

$rowset=$db->user();

$max_key=$rowset->max()->key;

$min_key=$rowset->min()->key

$sum_key=$rowset->sum()->key;

$average_key=$rowset->avg()->key ;or $rowset->average()->key;

This can be used with JOINS also.Just use the `tablealias_columnname` format while refereing to
columns for these functions.

Thanks,
Sandeep

regarding multiple OR ,
I assume by multiple or you mean clasues like ' or(condition 1 and condition 2)...'.

I am not sure if I should add that to the class. Could not find a neat way of adding it.

i have added support for OR groups,an OR group can be added as

$rowset=$db->user()->name('user')->or()->start_group()->no(50)->key(100)->end_group();

not very neat... i know...

Thanks for reply and thanks for this good class...
I'll definitely use this class in my future projects...

:)

Thanks!