Since moving from local storage to SAN storage our queries are requiring 2-10 times more time to return data. Does anyone have any advice/experience with this? Recommendations? Why is the SAN slower? We are using Oracle/Lawson tables/Unix environment. :?
Kenneth, I do not know about SAN storage. I’m guessing that you are using it on your WebI server?
Have you been able to isolate how long the queries run without WebI in the picture, that is, by submitted the SQL via another reporting tool? Is it possible that your query performance is different due to the upgrade to Oracle? (Perhaps Oracle 9.2.0.7 is using a different execution plan that is slower?) I think you first need to figure out whether the change is due to a change you made to the WebI server versus the change you made to the database.
Finally, what version of BusinessObjects/WebI are you using?