function FileData_Pairs(x) { x.t("example","sqlexecdirect"); x.t("example","again"); x.t("example","rowid"); x.t("example","applications"); x.t("reattaches","gathers"); x.t("statements","connection"); x.t("statements","instead"); x.t("statements","significantly"); x.t("statements","therefore"); x.t("active","connection"); x.t("active","reduce"); x.t("spending","time"); x.t("four","times"); x.t("complex","queries"); x.t("complex","query"); x.t("complex","sql"); x.t("sqlexecdirect","hstmt"); x.t("hidden","columns"); x.t("library","reattaches"); x.t("provide","autocommit"); x.t("provide","fastest"); x.t("provide","memory"); x.t("transactions","active"); x.t("transactions","transactions"); x.t("transactions","possible"); x.t("transactions","always"); x.t("transactions","required"); x.t("transactions","due"); x.t("transactions","committing"); x.t("transactions","least"); x.t("transactions","span"); x.t("transactions","help"); x.t("transactions","intervals"); x.t("possible","using"); x.t("available","example"); x.t("columns","determined"); x.t("columns","every"); x.t("columns","optimal"); x.t("columns","explicitly"); x.t("columns","possibly"); x.t("columns","part"); x.t("columns","calling"); x.t("columns","clause"); x.t("determined","using"); x.t("exist","call"); x.t("managing","commits"); x.t("managing","connections"); x.t("rather","two"); x.t("trips","necessary"); x.t("trips","needed"); x.t("autocommit","mode"); x.t("autocommit","connecting"); x.t("autocommit","commit"); x.t("throughput","holding"); x.t("right","transaction"); x.t("improved","performance"); x.t("sqlspecialcolumns","sqlspecialcolumns"); x.t("sqlspecialcolumns","consists"); x.t("sqlspecialcolumns","determine"); x.t("sqlspecialcolumns","consider"); x.t("sqlspecialcolumns","applications"); x.t("sqlspecialcolumns","hstmt"); x.t("fetch","data"); x.t("every","table"); x.t("every","statement"); x.t("every","operation"); x.t("every","data"); x.t("create","new"); x.t("commits","transactions"); x.t("table","example"); x.t("table","default"); x.t("table","definition"); x.t("table","unique"); x.t("build","complex"); x.t("once","using"); x.t("source","autocommit"); x.t("source","contain"); x.t("source","establishing"); x.t("intensive","slow"); x.t("always","turn"); x.t("required","support"); x.t("required","avoid"); x.t("normal","transactions"); x.t("improve","performance"); x.t("improve","system"); x.t("components","involved"); x.t("apply","types"); x.t("optimal","columns"); x.t("optimal","unique"); x.t("addressed","implementation"); x.t("searched","write"); x.t("current","cursor"); x.t("zip","emp"); x.t("zip","rowid"); x.t("zip","sql_nts"); x.t("user","sqlexecdirect"); x.t("user","table"); x.t("ssn","address"); x.t("statement","issued"); x.t("statement","handles"); x.t("statement","begin"); x.t("statement","handling"); x.t("statement","simply"); x.t("statement","process"); x.t("physical","connection"); x.t("support","transactions"); x.t("support","autocommit"); x.t("support","special"); x.t("support","distributed"); x.t("mode","type"); x.t("mode","usually"); x.t("mode","performance"); x.t("necessary","communicate"); x.t("state","zip"); x.t("times","slower"); x.t("times","throughout"); x.t("times","preventing"); x.t("close","physical"); x.t("type","server"); x.t("deletes","makes"); x.t("deletes","positioned"); x.t("deletes","sqlsetpos"); x.t("deletes","applications"); x.t("change","data"); x.t("searchable","result"); x.t("time","thoughtfully"); x.t("time","good"); x.t("sequential","write"); x.t("explicitly","issue"); x.t("explicitly","defined"); x.t("fairly","complex"); x.t("connection","active"); x.t("connection","statement"); x.t("connection","connection"); x.t("connection","pooling"); x.t("connection","handles"); x.t("connection","database"); x.t("connection","although"); x.t("connection","call"); x.t("connection","management"); x.t("connection","bad"); x.t("connection","pool"); x.t("multiple","statement"); x.t("multiple","connections"); x.t("multiple","sql"); x.t("dll","shared"); x.t("entities","pass"); x.t("needed","create"); x.t("needed","row"); x.t("needed","commit"); x.t("back","disk"); x.t("default","autocommit"); x.t("penalty","paid"); x.t("sqlcolumns","determine"); x.t("updates","managing"); x.t("updates","improve"); x.t("updates","apply"); x.t("updates","deletes"); x.t("updates","usually"); x.t("updates","guidelines"); x.t("updates","designing"); x.t("updates","either"); x.t("disconnect","several"); x.t("new","connection"); x.t("new","data"); x.t("servers","provide"); x.t("access","data"); x.t("emp","sqlexecdirect"); x.t("emp","address"); x.t("emp","sql_nts"); x.t("sqlspecialcolumns/sql_best_rowid","retrieve"); x.t("consists","columns"); x.t("designed","advantage"); x.t("designed","separate"); x.t("designed","call"); x.t("usually","result"); x.t("usually","impairs"); x.t("need","allocate"); x.t("need","call"); x.t("again","sqlspecialcolumns"); x.t("optimize","application"); x.t("improves","application"); x.t("issued","application"); x.t("holding","locks"); x.t("network","round"); x.t("network","requests"); x.t("network","world"); x.t("leaving","transactions"); x.t("due","logging"); x.t("unless","distributed"); x.t("informational","gathering"); x.t("large","amount"); x.t("pooling","especially"); x.t("pooling","closing"); x.t("locks","rows"); x.t("fetchdata","sqlexecdirect"); x.t("specified","table"); x.t("guidelines","section"); x.t("wide","web"); x.t("slow","driver"); x.t("operation","database"); x.t("operation","sent"); x.t("maintainable","positioned"); x.t("rowid","user"); x.t("rowid","emp"); x.t("rowid","tid"); x.t("rowid","sql_nts"); x.t("rowid","using"); x.t("possibly","pseudo-column"); x.t("definition","hidden"); x.t("definition","returned"); x.t("performance","connection"); x.t("performance","penalty"); x.t("performance","optimize"); x.t("performance","maintainability"); x.t("performance","optimization"); x.t("performance","odbc"); x.t("performance","database"); x.t("performance","tip"); x.t("performance","significant"); x.t("changed","needed"); x.t("changed","addition"); x.t("changed","designer"); x.t("handles","example"); x.t("handles","provide"); x.t("handles","multiple"); x.t("handles","instead"); x.t("handles","process"); x.t("handles","manage"); x.t("handles","associated"); x.t("avoid","connecting"); x.t("avoid","using"); x.t("maintainability","managing"); x.t("logging","network"); x.t("sqlstatistics","find"); x.t("part","unique"); x.t("part","explicit"); x.t("slower","normal"); x.t("updating","data"); x.t("methods","typically"); x.t("exists","therefore"); x.t("hdbc","pointer"); x.t("developers","positioned"); x.t("makes","sense"); x.t("determine","optimal"); x.t("determine","pseudo-columns"); x.t("find","columns"); x.t("find","smallest"); x.t("gathers","information"); x.t("web","connection"); x.t("address","rowid"); x.t("address","first_name"); x.t("address","city"); x.t("optimization","managing"); x.t("gather","step"); x.t("record","databases"); x.t("record","already"); x.t("record","pseudo-columns"); x.t("thoughtfully","handling"); x.t("write","searched"); x.t("write","replace"); x.t("allow","maximum"); x.t("allow","developer"); x.t("local","transactions"); x.t("second","connection"); x.t("round","trips"); x.t("addition","large"); x.t("addition","making"); x.t("three","network"); x.t("contain","special"); x.t("gathering","routines"); x.t("gathering","driver"); x.t("begin","transaction"); x.t("designer","forced"); x.t("supplies","data"); x.t("choosing","right"); x.t("queries","consider"); x.t("point","exact"); x.t("especially","applications"); x.t("committing","data"); x.t("disk","every"); x.t("disk","i/o"); x.t("involve","database"); x.t("involved","distributed"); x.t("connecting","once"); x.t("connecting","data"); x.t("collection","routine"); x.t("long","times"); x.t("select","statement"); x.t("select","first_name"); x.t("databases","support"); x.t("communicate","components"); x.t("maximum","concurrency"); x.t("signal","driver"); x.t("fastest","access"); x.t("retrieve","optimal"); x.t("hide","rowid"); x.t("cannot","designed"); x.t("advantage","positioned"); x.t("may","formulate"); x.t("unique","index"); x.t("odbc","applications"); x.t("odbc","driver"); x.t("instead","local"); x.t("instead","performing"); x.t("instead","establishing"); x.t("instead","applications"); x.t("step","rather"); x.t("requests","every"); x.t("requests","connection"); x.t("replace","existing"); x.t("reduce","throughput"); x.t("accessing","rows"); x.t("row","available"); x.t("row","changed"); x.t("row","select"); x.t("row","located"); x.t("index","specified"); x.t("index","methods"); x.t("index","exists"); x.t("first_name","last_name"); x.t("section","help"); x.t("handling","addressed"); x.t("handling","connection"); x.t("types","applications"); x.t("internal","pointer"); x.t("returned","sqlcolumns"); x.t("returned","result"); x.t("tid","pseudo-columns"); x.t("important","application"); x.t("initial","connection"); x.t("cursor","sqlsetpos"); x.t("cursor","appropriate"); x.t("simply","supplies"); x.t("performance-expensive","operations"); x.t("calling","sqlstatistics"); x.t("explicit","table"); x.t("steps","odbc"); x.t("connected","hdbc"); x.t("rows","long"); x.t("rows","commit"); x.t("designing","odbc"); x.t("often","efficient"); x.t("often","pseudo-columns"); x.t("reused","avoiding"); x.t("located","server"); x.t("identifies","given"); x.t("performing","multiple"); x.t("throughout","application"); x.t("memory","storage"); x.t("database","servers"); x.t("database","cursor"); x.t("database","application"); x.t("database","server"); x.t("avoiding","network"); x.t("issue","commit"); x.t("least","four"); x.t("given","record"); x.t("exact","location"); x.t("previous","example"); x.t("span","multiple"); x.t("forming","clause"); x.t("establish","connection"); x.t("closing","connections"); x.t("extremely","disk"); x.t("existing","data"); x.t("concurrency","choosing"); x.t("consider","previous"); x.t("consider","following"); x.t("amount","disk"); x.t("last_name","ssn"); x.t("establishing","second"); x.t("establishing","initial"); x.t("routines","record"); x.t("allocate","new"); x.t("far","leaving"); x.t("already","connected"); x.t("already","attached"); x.t("already","positioned"); x.t("several","times"); x.t("implementation","spending"); x.t("developer","signal"); x.t("connections","close"); x.t("connections","connection"); x.t("connections","updates"); x.t("connections","avoid"); x.t("connections","distributed"); x.t("process","performance-expensive"); x.t("process","sql"); x.t("actually","involve"); x.t("forced","build"); x.t("making","application"); x.t("pseudo-column","identifies"); x.t("although","gathering"); x.t("although","positioned"); x.t("although","using"); x.t("systems","support"); x.t("help","application"); x.t("help","manage"); x.t("good","practice"); x.t("separate","dll"); x.t("separate","entities"); x.t("page","contains"); x.t("tip","far"); x.t("consisting","subset"); x.t("location","record"); x.t("data","columns"); x.t("data","table"); x.t("data","source"); x.t("data","sequential"); x.t("data","changed"); x.t("data","collection"); x.t("data","often"); x.t("data","forming"); x.t("data","extremely"); x.t("data","although"); x.t("data","page"); x.t("data","data"); x.t("data","probably"); x.t("data","positioning"); x.t("data","typically"); x.t("information","connect"); x.t("information","driver"); x.t("information","sql"); x.t("attached","connection"); x.t("routine","instead"); x.t("routine","separate"); x.t("preventing","users"); x.t("positioned","updates"); x.t("positioned","row"); x.t("sqlsetpos","allow"); x.t("sqlsetpos","update"); x.t("query","applications"); x.t("practice","often"); x.t("practice","connect"); x.t("shared","library"); x.t("appropriate","row"); x.t("result","columns"); x.t("result","improved"); x.t("result","sqlspecialcolumns"); x.t("result","fairly"); x.t("result","applications"); x.t("defined","user"); x.t("probably","hide"); x.t("application","need"); x.t("application","maintainable"); x.t("application","performance"); x.t("application","connecting"); x.t("application","requests"); x.t("application","process"); x.t("application","although"); x.t("significantly","improve"); x.t("intervals","allow"); x.t("locate","row"); x.t("values","returned"); x.t("sql_nts","fetch"); x.t("sql_nts","fairly"); x.t("sql_nts","fetchdata"); x.t("sql_nts","fastest"); x.t("efficient","gather"); x.t("city","state"); x.t("two","steps"); x.t("flush","back"); x.t("transaction","every"); x.t("transaction","unless"); x.t("transaction","model"); x.t("users","accessing"); x.t("sense","positioned"); x.t("subset","column"); x.t("column","values"); x.t("applications","managing"); x.t("applications","statement"); x.t("applications","designed"); x.t("applications","need"); x.t("applications","performance"); x.t("applications","developers"); x.t("applications","cannot"); x.t("applications","may"); x.t("applications","establish"); x.t("applications","typically"); x.t("applications","call"); x.t("applications","connect"); x.t("significant","amount"); x.t("positioning","database"); x.t("typically","point"); x.t("typically","internal"); x.t("typically","work"); x.t("typically","update"); x.t("work","result"); x.t("call","sqlspecialcolumns"); x.t("call","sqlspecialcolumns/sql_best_rowid"); x.t("call","informational"); x.t("call","sqlstatistics"); x.t("call","routine"); x.t("hstmt","emp"); x.t("hstmt","select"); x.t("hstmt","update"); x.t("manage","multiple"); x.t("manage","connections"); x.t("system","performance"); x.t("management","improves"); x.t("management","important"); x.t("pointer","row"); x.t("pointer","data"); x.t("storage","information"); x.t("turn","autocommit"); x.t("model","systems"); x.t("either","update"); x.t("clause","updating"); x.t("clause","consisting"); x.t("clause","using"); x.t("following","example"); x.t("special","columns"); x.t("special","pseudo-columns"); x.t("smallest","unique"); x.t("using","transactions"); x.t("using","sqlspecialcolumns"); x.t("using","searchable"); x.t("using","multiple"); x.t("using","instead"); x.t("using","positioned"); x.t("connect","time"); x.t("connect","disconnect"); x.t("connect","network"); x.t("paid","three"); x.t("pass","already"); x.t("bad","practice"); x.t("i/o","intensive"); x.t("i/o","required"); x.t("i/o","needed"); x.t("distributed","transactions"); x.t("distributed","transaction"); x.t("driver","support"); x.t("driver","change"); x.t("driver","explicitly"); x.t("driver","information"); x.t("driver","applications"); x.t("sql","statements"); x.t("sql","statement"); x.t("associated","statement"); x.t("therefore","application"); x.t("therefore","applications"); x.t("world","wide"); x.t("operations","locate"); x.t("commit","transactions"); x.t("commit","every"); x.t("commit","statement"); x.t("commit","actually"); x.t("impairs","system"); x.t("pool","reused"); x.t("sent","server"); x.t("pseudo-columns","provide"); x.t("pseudo-columns","exist"); x.t("pseudo-columns","part"); x.t("pseudo-columns","result"); x.t("server","addition"); x.t("server","odbc"); x.t("server","already"); x.t("server","flush"); x.t("server","typically"); x.t("contains","updated"); x.t("updated","new"); x.t("update","current"); x.t("update","emp"); x.t("update","data"); x.t("formulate","clause"); }