APplication performance issue : SqlServer & Oracle
- by Mahesh
Hi,
We have a applicaiton in Silverlight,WCF, NHibernate.
Currently it is supporting SQL Serve and Oracle database.
As it's huge data, it is running ok on SQL Sevrer. But on Oracle it is running very slow.
For one functionality it takes 5 Sec to execute on SQL Server and 30 Sec on Oracle. I am not able to figure out what will be issue.
Two things that i want to share with you about our database.
1) Database: contains one base table contains column of type
SQLServer: [Text]
Oracle: [NCLOB]
2) Our database structure is too much normalized.
May be in the oracle i have used NCLOB, that is the cause of the performance. I mean i don't know the details about it....
Can anyone please let me know what will be cause?
Or
Which actions do i need to follw to improve the performance as equal as SqlServer.?
Thanks in advance.
Mahesh.