|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() ?
|2009-04-01 04:40:01 - In reply to message 1 from saurabh sharma|
|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 ,
$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.
|2009-04-01 04:44:01 - In reply to message 1 from saurabh sharma|
|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.
|2009-04-01 12:49:41 - In reply to message 3 from Sandeep.C.R|
|i have added support for OR groups,an OR group can be added as|
not very neat... i know...
|2009-04-01 16:14:13 - In reply to message 2 from Sandeep.C.R|
|Thanks for reply and thanks for this good class...|
I'll definitely use this class in my future projects...