Counting same

i am using CountOccurrence (String Spectral) from woei, on the oher hand i got a huge amount of strings( 50000+), and this combination makes vvvv crashing down, i know its no suprise but i need to count that strings!

is there an alternative node?

where do those strings come from? A textfile or MYSQL-database?

sql

its the date,

like

1997
1996
1996

Isn´t there a clever MySQL-function that could sort things out for you?
Maybe Google knows:

count distinct mysql

this should help you:

http://www.w3schools.com/sql/sql_groupby.asp

jeah this is one tought i also had, but the date is cutted with RegExpr, original its like 01.01.1999. i will watch for a similar function in sql…