General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Dragan, Thanks.
This is just an "aside" to the main conversation. I am trying to understand your post.
Are you telling me that if my views had no joins and instead I simply pulled each tables data that is needed separately, then using cursors somehow end up with the same data as I was pulling with a view that contained joins, I would be a lot faster?
If that is what you are saying, I understand. In the testing I have done I have noticed, I can pull a million records from a table with no joins in just a few seconds. Add even the simplest join (on indexed fields) and it will almost always, if not always, be many times slower.
All that said, with 1000 views and 80% of those views having at least 1 join, that would seem to be an impossible task.
Thanks for any clarification,
John
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only