function FileData_Pairs(x) { x.t("min","pool"); x.t("ignore","value"); x.t("example","suppose"); x.t("example","application"); x.t("four","round"); x.t("statements","multiple"); x.t("statements","however"); x.t("statements","allows"); x.t("statements","allowing"); x.t("statements","per"); x.t("decrease","application"); x.t("active","statements"); x.t("active","statement"); x.t("considerations","performance"); x.t("considerations","sybase"); x.t("considerations","following"); x.t("(connectionpooling)","enable"); x.t("available","setting"); x.t("columns","(defaultlongdatabufflen)"); x.t("method","encryptionmethod"); x.t("method","connection"); x.t("method","increase"); x.t("method","(optimizeprepare)"); x.t("method","option"); x.t("method","note"); x.t("method","(selectmethod)"); x.t("(0)","option"); x.t("balance","timeout"); x.t("improved","packetsize"); x.t("improved","creating"); x.t("improved","performance"); x.t("fetch","200"); x.t("fetch","array"); x.t("fetch","rows"); x.t("trips","required"); x.t("trips","network"); x.t("200","rows"); x.t("oversized","buffer"); x.t("refer","chapter"); x.t("trade-off","consider"); x.t("encryptionmethod","data"); x.t("failover","mode"); x.t("keep","connections"); x.t("timespan","exceeds"); x.t("binary","data"); x.t("required","encrypt"); x.t("required","return"); x.t("once","executed"); x.t("improve","performance"); x.t("improve","driver"); x.t("(enablebulkload)","application"); x.t("performs","bulk"); x.t("optimal","client"); x.t("locking","prevents"); x.t("current","time"); x.t("destroyed","min"); x.t("improving","performance"); x.t("packetsize","attribute"); x.t("prepared","statements"); x.t("prepared","statement"); x.t("coordinate","operations"); x.t("last","used"); x.t("fetching","size"); x.t("uses","multiple"); x.t("errors","driver"); x.t("mode","(failovermode)"); x.t("statement","however"); x.t("statement","processing"); x.t("statement","executed"); x.t("statement","defined"); x.t("statement","result"); x.t("(defaultlongdatabufflen)","improve"); x.t("vary","calculate"); x.t("times","performance"); x.t("times","row"); x.t("times","prepare"); x.t("calls","different"); x.t("time","fetch"); x.t("time","timespan"); x.t("time","connection"); x.t("time","during"); x.t("time","network"); x.t("time","application"); x.t("reset","resetting"); x.t("connection","active"); x.t("connection","destroyed"); x.t("connection","last"); x.t("connection","reset"); x.t("connection","default"); x.t("connection","become"); x.t("connection","pooling"); x.t("connection","string"); x.t("connection","options"); x.t("connection","unique"); x.t("connection","initial"); x.t("connection","issue"); x.t("connection","option"); x.t("connection","pool"); x.t("however","prepared"); x.t("however","setting"); x.t("however","ideal"); x.t("total","number"); x.t("multiple","active"); x.t("multiple","times"); x.t("exceeds","value"); x.t("resetting","re-used"); x.t("default","setting"); x.t("default","buffer"); x.t("text","binary"); x.t("details","application"); x.t("low","cause"); x.t("retrieved","otherwise"); x.t("bulk","loading"); x.t("bulk","load"); x.t("single","sql"); x.t("size","connection"); x.t("size","large"); x.t("size","specified"); x.t("size","approximate"); x.t("size","bytes"); x.t("size","slightly"); x.t("size","option"); x.t("size","accommodate"); x.t("size","database"); x.t("size","1024"); x.t("size","long/lob"); x.t("size","sybase"); x.t("size","data"); x.t("size","(arraysize)"); x.t("size","(packetsize)"); x.t("size","packet"); x.t("size","setting"); x.t("size","conjunction"); x.t("size","127"); x.t("size","increased"); x.t("amounts","data"); x.t("adversely","affect"); x.t("cpu","usage"); x.t("during","four"); x.t("exceed","load"); x.t("images","pictures"); x.t("(failovermode)","although"); x.t("network","fetch"); x.t("network","thereby"); x.t("network","packet"); x.t("normally","fetches"); x.t("leaving","space"); x.t("increase","performance"); x.t("results","without"); x.t("become","available"); x.t("large","amounts"); x.t("large","enough"); x.t("configuring","driver"); x.t("availability","replays"); x.t("locks","although"); x.t("pooling","(connectionpooling)"); x.t("pooling","additional"); x.t("high","availability"); x.t("high","overhead"); x.t("high","wastes"); x.t("specified","connection"); x.t("constraints","encryption"); x.t("settings","impacts"); x.t("connects","database"); x.t("functionality","instead"); x.t("functionality","bypass"); x.t("creating","stored"); x.t("stored","procedure"); x.t("faster","executing"); x.t("performance","example"); x.t("performance","decrease"); x.t("performance","considerations"); x.t("performance","improved"); x.t("performance","improve"); x.t("performance","configuring"); x.t("performance","reduced"); x.t("performance","optimization"); x.t("performance","select"); x.t("performance","enhance"); x.t("performance","additional"); x.t("performance","application"); x.t("performance","efficient"); x.t("performance","using"); x.t("performance","load"); x.t("performance","negatively"); x.t("performance","therefore"); x.t("performance","increased"); x.t("populated","connections"); x.t("retains","number"); x.t("approximate","number"); x.t("accordingly","enable"); x.t("bytes","network"); x.t("bytes","row"); x.t("bytes","rows"); x.t("bytes","dividing"); x.t("fit","network"); x.t("reduced","transferring"); x.t("provides","increased"); x.t("datadirect","connect"); x.t("transferring","large"); x.t("loading","data"); x.t("allows","reduces"); x.t("allows","application"); x.t("wire","protocol"); x.t("optimization","datadirect"); x.t("coordinates","concurrent"); x.t("concurrent","database"); x.t("string","connects"); x.t("array","size"); x.t("array","binding"); x.t("integrity","constraints"); x.t("thereby","increasing"); x.t("sets","fetched"); x.t("attribute","maximum"); x.t("attribute","disabled"); x.t("contain","low"); x.t("round","trips"); x.t("retrieves","data"); x.t("allowing","server"); x.t("commands","server"); x.t("queries","failure"); x.t("calculate","number"); x.t("calculate","ideal"); x.t("decrypt","data"); x.t("know","size"); x.t("suppose","network"); x.t("options","affect"); x.t("options","enhance"); x.t("reason","coordinate"); x.t("long","keep"); x.t("long","text"); x.t("first","connection"); x.t("minimum","pool"); x.t("replays","queries"); x.t("select","statements"); x.t("select","method"); x.t("space","packet"); x.t("smaller","network"); x.t("executing","single"); x.t("executing","stored"); x.t("cause","high"); x.t("cause","delays"); x.t("cause","connections"); x.t("re-used","connection"); x.t("number","high"); x.t("number","round"); x.t("number","rows"); x.t("number","connections"); x.t("processing","closing"); x.t("design","refer"); x.t("max","pool"); x.t("maximum","size"); x.t("maximum","number"); x.t("maximum","amount"); x.t("maximum","packet"); x.t("enough","accommodate"); x.t("chapter","designing"); x.t("different","threads"); x.t("define","long"); x.t("unique","connection"); x.t("pictures","long"); x.t("may","adversely"); x.t("odbc","calls"); x.t("odbc","reference"); x.t("odbc","applications"); x.t("instead","database"); x.t("row","size"); x.t("applicationusingthreads","attribute"); x.t("encrypt","decrypt"); x.t("(optimizeprepare)","application"); x.t("initial","configuration"); x.t("cursor","option"); x.t("reference","details"); x.t("enable","bulk"); x.t("enable","application"); x.t("enable","driver"); x.t("system's","bulk"); x.t("rows","fetching"); x.t("rows","times"); x.t("rows","time"); x.t("rows","fit"); x.t("rows","fetched"); x.t("rows","result"); x.t("rows","efficient"); x.t("reduces","total"); x.t("reduces","number"); x.t("client","maximum"); x.t("client","thus"); x.t("prepare","method"); x.t("prepare","time"); x.t("executed","once"); x.t("executed","performance"); x.t("designing","odbc"); x.t("disabled","note"); x.t("slightly","smaller"); x.t("return","results"); x.t("return","data"); x.t("thus","improving"); x.t("often","executes"); x.t("database","array"); x.t("database","cursor"); x.t("database","system's"); x.t("database","cursors"); x.t("database","operations"); x.t("database","pool"); x.t("database","server"); x.t("option","fetch"); x.t("option","connection"); x.t("option","know"); x.t("option","select"); x.t("option","cause"); x.t("option","application"); x.t("option","causes"); x.t("option","used"); x.t("affect","performance"); x.t("issue","additional"); x.t("accommodate","maximum"); x.t("previous","result"); x.t("enhance","performance"); x.t("enhance","driver"); x.t("(applicationusingthreads)","driver"); x.t("acquiring","locks"); x.t("compared","current"); x.t("consider","improved"); x.t("encryption","method"); x.t("encryption","may"); x.t("1024","bytes"); x.t("1024","equals"); x.t("closing","previous"); x.t("configuration","settings"); x.t("long/lob","columns"); x.t("amount","data"); x.t("failure","provides"); x.t("additional","commands"); x.t("additional","options"); x.t("additional","overhead"); x.t("value","connection"); x.t("value","default"); x.t("value","load"); x.t("usage","required"); x.t("delays","waiting"); x.t("bypass","data"); x.t("dividing","1024"); x.t("sybase","wire"); x.t("sybase","ase"); x.t("connections","ignore"); x.t("connections","exceed"); x.t("connections","minimum"); x.t("connections","pool"); x.t("connections","even"); x.t("waiting","connection"); x.t("fetched","cause"); x.t("fetched","reduces"); x.t("process","multiple"); x.t("although","locking"); x.t("although","high"); x.t("impacts","performance"); x.t("cursors","select"); x.t("data","oversized"); x.t("data","failover"); x.t("data","improve"); x.t("data","retrieved"); x.t("data","integrity"); x.t("data","client"); x.t("data","encryption"); x.t("data","buffer"); x.t("overhead","example"); x.t("overhead","fetch"); x.t("overhead","mainly"); x.t("overhead","server"); x.t("decreases","performance"); x.t("timeout","define"); x.t("timeout","option"); x.t("timeout","value"); x.t("protection","adversely"); x.t("(arraysize)","select"); x.t("(arraysize)","option"); x.t("(arraysize)","effect"); x.t("increasing","performance"); x.t("equals","128"); x.t("result","uses"); x.t("result","sets"); x.t("result","rows"); x.t("defined","statement"); x.t("application","performs"); x.t("application","vary"); x.t("application","multiple"); x.t("application","normally"); x.t("application","retrieves"); x.t("application","design"); x.t("application","odbc"); x.t("application","enable"); x.t("application","often"); x.t("application","process"); x.t("application","executes"); x.t("application","using"); x.t("application","fetches"); x.t("case","applicationusingthreads"); x.t("(packetsize)","typically"); x.t("efficient","application"); x.t("efficient","driver"); x.t("procedure","faster"); x.t("procedure","executing"); x.t("procedure","server"); x.t("protocol","driver"); x.t("note","using"); x.t("note","ideal"); x.t("otherwise","performance"); x.t("executes","prepared"); x.t("executes","sql"); x.t("(selectmethod)","application"); x.t("applications","performance"); x.t("prevents","errors"); x.t("typically","optimal"); x.t("created","stored"); x.t("created","first"); x.t("packet","size"); x.t("packet","leaving"); x.t("packet","calculate"); x.t("packet","overhead"); x.t("causes","driver"); x.t("following","connection"); x.t("multi-threaded","application"); x.t("used","compared"); x.t("used","conjunction"); x.t("connect","series"); x.t("using","bulk"); x.t("using","database"); x.t("using","multi-threaded"); x.t("using","threads"); x.t("setting","(0)"); x.t("setting","fetch"); x.t("setting","select"); x.t("setting","number"); x.t("setting","maximum"); x.t("setting","option"); x.t("setting","application"); x.t("mainly","cpu"); x.t("conjunction","fetch"); x.t("conjunction","select"); x.t("127","128"); x.t("series","odbc"); x.t("wastes","resources"); x.t("levels","protection"); x.t("ideal","setting"); x.t("128","however"); x.t("128","number"); x.t("per","connection"); x.t("driver","fetch"); x.t("driver","connection"); x.t("driver","performance"); x.t("driver","coordinates"); x.t("driver","reason"); x.t("driver","database"); x.t("driver","decreases"); x.t("driver","created"); x.t("operations","different"); x.t("operations","case"); x.t("operations","operations"); x.t("load","balance"); x.t("load","(enablebulkload)"); x.t("load","functionality"); x.t("negatively","connection"); x.t("therefore","performance"); x.t("sql","statements"); x.t("sql","statement"); x.t("without","using"); x.t("ase","server"); x.t("pool","time"); x.t("pool","size"); x.t("pool","populated"); x.t("pool","retains"); x.t("pool","contain"); x.t("pool","created"); x.t("even","connections"); x.t("buffer","size"); x.t("buffer","application"); x.t("fetches","200"); x.t("fetches","images"); x.t("fetches","rows"); x.t("increased","accordingly"); x.t("increased","overhead"); x.t("increased","levels"); x.t("threads","option"); x.t("threads","(applicationusingthreads)"); x.t("threads","acquiring"); x.t("threads","driver"); x.t("server","allows"); x.t("server","max"); x.t("server","prepare"); x.t("server","return"); x.t("server","application"); x.t("resources","min"); x.t("binding","trade-off"); }