Regression in VB6? MySQL?

[oboeguy]

I already have some code which will do it, but I'm wondering if there's a DLL or something out there that I can call from VB to avoid the obligatory performance hit (i.e. doing math in VB is slow).

Edit: VB6

Edit 2: my data is coming from MySQL so doing it with SQL would be cool if it were faster than VB (maybe just with less overhead it's the case who knows).

 

[Bulldog13]

Post your source code, maybe someone could port it.

 

[oboeguy]

I think whoever wrote it based it on "Numerical Recipes in C" so anyone willing to write a DLL can find it there.

BTW, apparently you can do regression using MySQL! "MySQL Cookbook" shows how to do it for a simple case. I need to do it for more variables, though, but if anyone wants to give it a shot... (I don't know the stats well enough to do it myself right now)

 

[oboeguy]

FYI, I ended-up getting a decent matrix package for VB. Doing the regression becomes pretty trivial with this in hand, and the hard work is done outside of VB thus is "cheaper" computationally. All around a good solution, for all of $50 (yes, this was for work).