Count in Emplode 2.0

It would be nice to have a count of the number of items under the current one in the 'soup' views, especially Genres and Years.

Just a thought.

Paul.

Paul Haigh, Reg. 4120
(mk1) 6GB, Blue, 00254
(mk2) 12GB, Red, 00357

Unfortunately, that'll require actually running the query. This is generally deferred until you actually click on the item in question.


-- roger

Could do it as a second pass, i suppose, similar to how encspot does the block counting for mp3 files.

Anyway, this is a wish list ..... .

Paul.

Paul Haigh, Reg. 4120
(mk1) 6GB, Blue, 00254
(mk2) 12GB, Red, 00357

Unfortunately, that'll require actually running the query. This is generally deferred until you actually click on the item in question.

So how do you generate the list of genres? Couldn't that query also tell you the count of each? (er, SELECT genre, COUNT(fid) FROM * GROUP BY genre, or something)

Peter

Yeah, yeah. Whatever.


-- roger

Ah, except that it proves to be impossible to keep the counts up-to-date without running the query every 5 seconds, and I'm not doing that unless I can make the queries go faster.


-- roger

They don't need to be re-run, just have them refresh on screen entry/redraw.

Then to refresh the counts, just click on 'genre' (or whatever) again.

That'd would be groovy, cool and most of all, really, really useful.

Cheers,

Paul.

Paul Haigh, Reg. 4120
(mk1) 6GB, Blue, 00254
(mk2) 12GB, Red, 00357