Guids causing Performance issues | Moving from SQL Server to Oracle| Urgent!!
Hi, I have been involved in project we where we need to re factor an existing application (ASP, VB .Net andSQL Server 2000). This application is basically a Questionnaire creating forms for end users to fill in some data. This information about forms is saved in form ofXML's in DB inClob. The way the code is written is when ever a new object is instantiated, a newGuid is requested and stored in DB along with other object information. Also each form consists of parts, sections and questions (each of which has aGuid attached). Now there are a couple of issues since the Database is not performing well, client want to move it to Oracle based system. This means that Guids now have to bestored in form of RAW 16 which hampers the performance badly. If we go on for replacing individual primary keys with standard oracle sequences, lot of code needs to be re factored as it is written forGuids and application can directly generate one any time and push it into DB. Now as and when the size of these forms is increasing, more and moreguids are associated within a form causing the size of XML to be huge (at times in megs) so moving away fromGuids has become a must now. Also when DB is queried forguids, oracle is not thatperformant as it would be simple sequence based primary keys. If any one has come across such a scenario, then please let me know the best way out of it. Any thoughts, suggestions or pointers would be very helpful. Regards, SanjeevPurohit
