Greetings! My name is Nick Haggmark and I am a lead developer for a company in South Florida. I'm new to this list, so this will be my first posting. Hello!
My team is currently developing our next mobile product and I have decided to incorporate Transfer in to serve as our ORM layer. One thing that I've been having issues with, however, is the apparent inability to alter the isolation levels of queries going into our SQL server 2005 database. In short, I would like to have the option of doing a dirty read. Now I realize that doing a dirty read creates all kinds of potential havoc when it comes to Transfer's complex caching system. I also realize the fundamental problems with working with uncommitted data. That being said, the question that I want to consider is this: We frequently have situations where we have chosen to do dirty reads because of extreme high volume on large tables and caching doesn't really seem to be an option due to infrequent reading of like data and JRUN memory issues (and we are still using CF7 on these servers). If I'm not planning on using Transfer to manage the caching on these tables (mostly using it to shorten development time) and I'm not worried about the nature of doing a dirty read, what is the harm of having that option if I can use it as a tool to boost query performance? While having the option certainly invites situations where problems can occur, it seems to me that omitting the ability hamstrings a developer who can use it responsibly (especially if you don't have the time or resources to completely redesign your app / data schema). Hopefully I have not invited a flame-fest on my first post. =) It just seemed like a reasonable question to pose. Any advice would be awesome. Thanks! Nick Haggmark --~--~---------~--~----~------------~-------~--~----~ Before posting questions to the group please read: http://groups.google.com/group/transfer-dev/web/how-to-ask-support-questions-on-transfer You received this message because you are subscribed to the Google Groups "transfer-dev" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/transfer-dev?hl=en -~----------~----~----~----~------~----~------~--~---
