> Issac, Isaac actually...
> I hope you understand that CURSORS are not the FASTEST > thing in SQL Server.. Absolutely... i use them ever so sparingly... > i have personally written many cursors > apps to > do BATCH Processing.. but i wouldnt recommend SQL Server > Cursors > for a REAL TIME processing.. Well in Oracle its a > different Story... > Depends on the DB. I agree T-SQL in <cfquery> doesnt look > clean.. > but for this situation... i think it will run faster. I'd be willing to bet money that the cursor in this stored procedure, run against a local temp table generated from a simple select statement on the information_schema.views table with no more than about 30 iterations ( I shudder to imagine the db table with more columns than this ) is faster and more efficient than 2 separate queries in CF server with a loop and ColdFusion conditional login in the 2nd query... Reason being that my understanding is that SQL Server engine internally doesn't have to wait for info to go out to another server, run a process and then come back, etc ... I've heard a lot of people say that db servers are generally faster than CF for a lot of things. We're also not talking about tables that are going to be particularly large -- admittedly, the sysobjects table has a few entries even in a new database, but you don't usually see a single db getting number of tables and or columns in the millions or billions like you sometimes do with rows in data tables. But then, to know for sure, we'd have to load test both. :) Isaac Certified Advanced ColdFusion 5 Developer www.turnkey.to 954-776-0046 ______________________________________________________________________ This list and all House of Fusion resources hosted by CFHosting.com. The place for dependable ColdFusion Hosting. FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Archives: http://www.mail-archive.com/[email protected]/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
