Dylan, OK represents the fact that the query has been sent successfully to the DB and the results were retured successfully back without encountering an error condition
Hope this helps.. Joe ________________________________ From: "Wheeler, Dylan" <[EMAIL PROTECTED]> To: [email protected] Sent: Wednesday, November 5, 2008 8:00:24 PM Subject: SQL Log question I'm wondering how I should read this sql log. Can someone help me out? /* Wed Nov 05 2008 15:01:47.4860 */SELECT helpText,changeDiary,objProp,owner,lastChanged FROM arschema WHERE (schemaId = 973) /* Wed Nov 05 2008 15:01:47.4860 */OK /* Wed Nov 05 2008 15:01:56.6300 */SELECT name, actlinkId, alOrder, executeMask, controlfieldId FROM actlink WHERE actlinkId IN(3556,3557,3558,3559,3560,3561,3562,3563,3941,3942,3943,3944,3945,3957,3958,3959,3960,3961,3962,3963,3964,3965,3966,3967,3968,3969,3970,3971,3972,3973,3974,3975,3977,3979,3980,3981,3982,3984,7880,7891,7893,7894,7952,7953,7954,7955,7956,7957,7958,7959,7960,7961,7962,7963,7964,7965,7966,7967,7968,7987,7988,7989,7990,7991,7992,7993,7994,8795,8796,10696,10697,10698,11145,11146,11147,11148,11149,11150,11151,11152,11153,11154,11155,11156,11157,11158,11159,11160,11161,11162,11163,11164,11165,11166,11167,11168,11169,11170,11171,11172,11173,11174,11175,11176,11177,11178,11179,11180,11181,11182,11183,11184,11185,11186,11187,11188,11189,11190,11191,11192,11193,11194,11195,11196,11197,11198,11199,11200,11201,11202,11203,11204,11205,11206,11207,11208,11209,11210,11211,11212,11213,11214,11215,11216,11217,11218,11219,11220,11221,11222,11223,11224,11225,11226,11227,11228,11229,11230,11231,11232,11233,11234,11235,11236,11237,11238,11239,11240,11241,11242,11243,11244, 11245,11246,11247,11248,11249,11250,11251,11252,11253,11254,11255,11256,11257,11258,11259,11260,11261,11262,11263,11264,11265,11266,11267,11268,11269,11270,11271,11272) ORDER BY 2 ASC /* Wed Nov 05 2008 15:01:56.7090 */OK There is a 8 second gap between the first query and the second. So my question is, does the OK line represent Remedy saying that it's ready to send the query off to SQL or does it represent that Remedy received the response from SQL and to move on to the next instruction. I'm trying to figure out why some operations are running really slow and the dba is asking me what the OK represents. Thanks for any help Dylan _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
