SPONSORS:






User Tag List

Thanks Thanks:  0
Likes Likes:  0
Dislikes Dislikes:  0
Results 1 to 5 of 5
  1. #1
    Junior Member
    Join Date
    Oct 2001
    Location
    NJ , USA
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    bind varibale in db vuser scripts

    I have to execute sql statement with parameterizing one of the varibale in WHERE clause.

    And, I wanted to see the db performance when we send a varible as bind varible to give the impression to db that we are sending same sql in each iteration and let it replace the sql with value we sent from bind varible.

    Can somebody help me with code example.
    kiran

  2. #2
    Moderator JakeBrake's Avatar
    Join Date
    Dec 2000
    Location
    St. Louis - Year 2025
    Posts
    15,609
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: bind varibale in db vuser scripts

    There should be an example in the help and/or tutorial help. Did you check? I think it will be a big help as I recall.
    Thanks!

  3. #3
    Junior Member
    Join Date
    Mar 2006
    Location
    Penang, Malaysia
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: bind varibale in db vuser scripts

    What db are you using?
    Strength Comes From Unity

  4. #4
    Junior Member
    Join Date
    Oct 2001
    Location
    NJ , USA
    Posts
    19
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: bind varibale in db vuser scripts

    I am using Oracle. I did look at example they gave in LR help, couldn't really get it. i appreciate your help.
    kiran

  5. #5
    Moderator JakeBrake's Avatar
    Join Date
    Dec 2000
    Location
    St. Louis - Year 2025
    Posts
    15,609
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    Total Downloaded
    0

    Re: bind varibale in db vuser scripts

    I'm confident you can do this! [img]images/icons/smile.gif[/img] Are you up for revisiting the help/Books Online? Specifically, the Virtual User Generator Online Help - Vugen - Client/Server Protocols - Developing Database Vuser Scripts - Getting Started With Database Vuser Scripts.

    Follow the hyperlinks. The explanations and examples are very robust.

    If I posted an example - it would be from that documentation and also a violation of copyright laws.

 

 

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Search Engine Optimisation provided by DragonByte SEO v2.0.36 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Resources saved on this page: MySQL 11.54%
vBulletin Optimisation provided by vB Optimise v2.6.4 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
User Alert System provided by Advanced User Tagging v3.2.8 (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
vBNominate (Lite) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Feedback Buttons provided by Advanced Post Thanks / Like (Pro) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
Username Changing provided by Username Change (Free) - vBulletin Mods & Addons Copyright © 2016 DragonByte Technologies Ltd.
BetaSoft Inc.
Digital Point modules: Sphinx-based search
All times are GMT -8. The time now is 03:37 AM.

Copyright BetaSoft Inc.