[dev] ansel performance (was "category performance")

[Chuck Hagenbuch]

Quoting Ben Chavet <ben at chavet.net>:

> I am willing to do most of the work, but I'd like to get some feedback so I
> can lay out my plan of attack before I start.  Let me know what you think.

That sounds like a pretty good analysis to me.

I'd ask, though, is it really beneficial to have a category for every image? For
the numbers you mentioned, that's 2200 categories.

What about, instead, having one category entry for the gallery details, and then
one category entry for *all* of the images in that category?

You'd still be fetching more data than necessary when viewing an individual
image, but you'd also have potentially more efficient fetching when viewing a
whole gallery.

Though, if you did it individually, it'd make the overhead of storing additional
attributes per image less, and we do batch-fetch multiple categories anyway.

-chuck

--
Charles Hagenbuch, <chuck at horde.org>
"I'm really... I'm not too fascinated by green food." - Average Joe