A Toy for all you Windows Utility writers...
I'm cross posting this from the EQEmu dev forum cause I'm a moron and really should have put it here, heh...
Post subject: A Toy for all you Windows Utility writers...
--------------------------------------------------------------------------------
I've began working with Melchoir on the SpawnED utility, and found an abscence in a quick and easy interface to MySQL from VB...
ODBC is clunky and slow, and other solutions I've found are quick but return native MySQL API structures. This is bad because VB grids and such heavily rely on ADODB Recordsets and such, so to populate a grid you'd need to for loop through the native MySQL structs to populate you're grid... and in VB, that sucks and is slow...
My Solution: I'm working on creating a COM interface to MySQL in VC++ that anyone should be able to call from VB and other COM enabled programming languages...
I already have the baseline of the code, and am currently adding features on an as needed basis, and squashing bugs...
So what does this mean? It means I can throw 86,000 records from the Spawn2 table into a grid in 8 seconds...
I hope to make it available to anyone who could find it useful, look here for new developments....
- Imaginator
|
Threaded Mode
