Results 1 to 4 of 4
  1. #1
    Join Date
    Sep 2002
    Location
    Guadalajara, Jalisco, Mexico
    Posts
    2

    Post Unanswered: Performance problem with Informix ODBC Driver 2.8

    Hi, I`m Alejandro ayala, I'm new in this group y now I have a problem in my application ( c++ builder 5.0 ) when the user logged is informix querys are so fast but when another users are logged performance query is so low, I give all grants and connect permission
    for users.

    Anybody can help me please, what is the problem origen ?

    thank's a lot

  2. #2
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    What database server do you use? Version?
    What is your setnet32 config.
    How about the ilogin demo, is it slow with other users?
    rws

  3. #3
    Join Date
    Sep 2002
    Location
    Guadalajara, Jalisco, Mexico
    Posts
    2
    Originally posted by Roelwe
    What database server do you use? Version?
    What is your setnet32 config.
    How about the ilogin demo, is it slow with other users?
    Hi Roelwe, thank's for your answer.

    My DD version is IDS2000 9.21 TC5 for Windows 2000
    Setnet Configuration is:

    Informix Sever: ol_digpres
    Host name: 10.23.3.15
    Protocol name: onsoctcp
    Service Name: 1526
    Options: None

    The ilogin demo with any user is normal ( so fast ) the same that with informix user.

    When run my application ( c++ builder ) and use the SQL monitor tool I see that when the user logged was informix a run a query total sql instructions executed using the ODBC driver client ( version 2.8 ) are few in comparation when other users are logged ( a lot of sql instructions are execute, like a sequential searching ).

    When run the same query in dbacces is fast, only using ODBC is slow.

    Thank's for your help

  4. #4
    Join Date
    Aug 2002
    Location
    Belgium
    Posts
    534
    Hi,

    Do you use ODBC from another machine?
    Did you check ilogin demo from another machine?
    I don't really see why the user informix runs faster qry's than another user... Normally user authentication is done by the os.
    Once the dbserver knows who, he just executes it.
    On ething you can do is try to trace your calls from server to client and vs versa.

    set the environment variable SQLIDEBUG=2:<path_to_debugfile>
    use the sqliprint to format the output.
    compare the two sqlidebu outputs and check where the problem lays.
    rws

Posting Permissions

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