Forum OpenACS Development: Response to PG Object Extensions

Forum OpenACS Development: Response to PG Object Extensions - pros and cons

12: Response to PG Object Extensions - pros and cons (response to 1)

Posted by Dan Wickstrom on 02/21/01 07:11 AM

Here it is:

         method          |  time   |    units
-------------------------+---------+--------------
 count(*) on acs_objects | 7.23621 | milliseconds
(1 row)
 
          method           |  time   |    units
---------------------------+---------+--------------
 count(*) on acs_objects2* | 9.97299 | milliseconds
(1 row)
 
          method          |  time   |    units
--------------------------+---------+--------------
 count(*) on acs_objects2 | 2.89982 | milliseconds
(1 row)
 
acspg=#

The first case is the acs classic case, and the second and third cases are with inheritance. The only difference being that I'm selecting from acs_objects* in the second case.