tag:blogger.com,1999:blog-497787815177352569.post1331406261549139375..comments2024-01-03T08:55:04.827-05:00Comments on SQL Anywhere: How To Make SQL Anywhere SlowBreck Carterhttp://www.blogger.com/profile/15975598564711761434noreply@blogger.comBlogger3125tag:blogger.com,1999:blog-497787815177352569.post-4358433850220756482008-11-21T03:27:00.000-05:002008-11-21T03:27:00.000-05:00That's a very nice post. We have an old applicatio...That's a very nice post. We have an old application written in .NET which uses SQL Anywhere 10. Our application has a poorly written function which executes mulitple queries consisting of joins and this function is called inside a loop.<BR/><BR/>We need to optimize the function. However I noticed that when we changed over to SQL Anywhere 11, it started taking a lot more time than it took with version 10. We even did an unload and reload to change to ver 11 file format.<BR/><BR/>Any ideas on why Ver 11 is making a slow code even slower? Thanks.Sachin Palewarhttps://www.blogger.com/profile/14680182741068698419noreply@blogger.comtag:blogger.com,1999:blog-497787815177352569.post-3374202617471124892008-04-24T21:42:00.000-04:002008-04-24T21:42:00.000-04:00My favourite is a real application that fetched al...My favourite is a real application that fetched all rows from the same query about 10,000 times in around 2 minutes. The app could have been rewritten to only fetch these rows once.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-497787815177352569.post-6103933613050231652008-04-02T20:15:00.000-04:002008-04-02T20:15:00.000-04:00Google now shows one result for "How to Make Oracl...Google now shows one result for "How to Make Oracle Slow". No prizes for guessing where that link goes to though.tom s.https://www.blogger.com/profile/02843516091868469912noreply@blogger.com