[Deprecated] DMZ 1.5.3 (DataMapper OverZealous Edition)

[eluser]OverZealous[/eluser]
[quote author="Mirage" date="1253171236"]New question - why does DMZ do a query every time a dmz object is created?[/quote]

I assume you are referring to these queries:

Code:

SELECT * FROM $table LIMIT 1

If so, those are used by CI to determine the names of the columns on the table. DMZ needs the result of these queries to work. (It's a core feature.)

They are only called once per model class, per session. They aren't used every time a model is created (every copy of a model shares a copy field data, validation info, and more).

Now, there are two things about these:

1) Almost without question, they have no real performance impact. I've tested those queries on my server, and the DB returns them in like 0.001 seconds.

2) If they really bother you, when you head off to production, enabled the Production Cache. But please heed the big red warnings on that page. I doubt it will provide any performance increase for less than 100 page views/minute, so testing is worth it.