Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Posts
    1

    Unanswered: RapidSQL & Sybase

    Performance problem

    RapidSql - Win2000 on Sybase 12.5 Database

    Select * from table1 where a= "1234" submitted from rapidSql

    consume more than 1 hours for a scan table on ~ 400.000 rows

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Switzerland
    Posts
    524
    What's the status of the running select using RapidSQL ? Are you locked by an other user ?

    Else, execute the same query using isql

    1) time using isql
    2) showplan using isql
    3) showplan using RapidSQL*

    *can be catched using sp_showplan spid,null,null,null via a parallel isql session

  3. #3
    Join Date
    Nov 2003
    Posts
    10

    Re: RapidSQL & Sybase

    The optimizer uses table scan if its unable to find any useful index.
    Create Index on your column and execute your query. It shouldn't take time.

    Originally posted by djv237
    Performance problem

    RapidSql - Win2000 on Sybase 12.5 Database

    Select * from table1 where a= "1234" submitted from rapidSql

    consume more than 1 hours for a scan table on ~ 400.000 rows

    Thanks

Posting Permissions

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