xgo

"sideway question: what would be the best way to monitor network card usage on twinfin?"

"thanks Fox it works.   I changed the install file like this nzudxcompile group_concat.cpp \ --sig           "group_concat(nvarchar(2000),n"

"Shawn Fox wrote:   Here are two versions of a MySQL like group_concat aggregate that I've written.  One is written using our C++ UDX method"

"the optimal amount of connections that stream data into netezza is the amount of cpu-s u have on your nz host."

"did u try with one single sql?why distribute on 3 keys? distribute is only usefull for joining 2 big tablesdid u try distribute on randomare"

"its hard to tell from the little info on your computation, width of the table, ...   but from my expirience with Netezza its best to proces"

"Dont split the table. Try to : - get best ORGANIZE ON columns - use a MATERIALIZED VIEW (if u query only a few columns regulary) - or use"