I have a code generator for sql server databases, and I want to switch it over to using SMO instead of my custom built queries, but it's just painfully slow right now. With my custom stuff, I get complete generation in about 5 seconds, with SMO, it runs in about 12 minutes ( I got this down from about 45 minutes on the first run by setting my defaultinitfields to everything, and prefetching everything).
90% of the time is taken up in looking up the parameters for storedprocedures, as well as looking at the foreign keys of a table.
You can't set defaultinitfields on collections ( at least not that I can figure out), so what can I do?
Come on guys, this is supposedly a professional product. It's been almost two weeks and not a single developer has cared to provide a response?
And no, this isn't a bump, it's someone that's trying to get work done with something that looks to be completely inadequate, and hasn't received a bit of attention.
-- Colin
No comments:
Post a Comment