Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2007
    Posts
    5

    Unanswered: Slow Query with IAnywhere

    Hello,

    I have an IAnywhere database with around 75 tables. I have a script that I routinely run against these tables to filter out the information I need, but for some reason the performace has gotten very slow. (taking about 10 times longer).


    Now admittedly I have added 3-5 columns (which aren't being searched in the query) to most of the tables, but I wouldn't think that would affect the time it takes to run a queries very much. Currently the queries are taking 10-20 times longer than prior to my addition of the new columns.


    Just curious if anyone has had a similar issue.

    Thanks,
    Matt

  2. #2
    Join Date
    Mar 2008
    Posts
    1
    Try posting your question on a forum dedicated to SQL Anywhere: sybase.public.sqlanywhere.general on the forums.sybase.com newsgroup server.

    Include the SQL for the query and base tables, and tell us what version you are using.

    There are a zillion things to look for when dealing with performance problems. Like hard drive fragmentation; setting for the OPTIMIZATION_GOAL database option (should probably be 'All-rows'); have a look at the "graphical plan with statistics" in dbisql (and you can save/send me the plan in XML to look at), and so on.

    Breck

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •