The FISO Guide to FPL Price Changes (The Code Thread) 08/09

Murder1 · **Joined:** Sat Oct 18 2008 **Posts:** 1283

diamondplus wrote:

Murder1 wrote:

All depends how much dev time you're prepared and can afford to put in d+.

I'm currently trying to emulate what you have in C# and SQL and the the whole load is done in 2-3 minutes including getting the 1dp %age ownership figure from the player info page, I'm just not sure whether I perform all the data checks that you do.

Show off!

Actually, I've done a lot of the recoding today in T-SQL and, fingers crossed, it's going well. With VBA/Recordsets you're essentially doing loads of loops, whereas with SQL Server you're dealing with Set theory which actually lends itself more to the original problem.

The other problem I've got is the PC I'm running it on is really slow and old (about six years I think) so if nothing else, the harddrive gets thrashed on large amounts of data.

The other, other problem is that my original VBA code is very sloppy indeed!

Trust me there's nothing to show off about :oops:

If I'd had to do this from scratch I'd have got nowhere it's only thanks to yourself and others on this thread that I've had any idea what needs to be logged.

The FISO Guide to FPL Price Changes (The Code Thread) 08/09

Who is online