connections throught odbc vs. informix 4gl program
Posted in 2001
Topics: Performance & Tuning, Connectivity: ODBC / JDBC / .NET, Connectivity: ESQL/C, 4GL & Embedded SQL, Server Administration
This is a multi-part message in MIME format. ------=_NextPart_000_0008_01C07964.B33A3240 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi all : Actually I have two servers, one for informix and 4gl programs, and the other for informix and connections throught odbc. I would like to change this shema, i mean i like to have one server for development and the other for produccion. but am i not sure about how can impact the performance if i combine connections throught odbc and connections trhought i4gl programs, can anybody help me ? Jorge Valenzuela DBA UABC. ------=_NextPart_000_0008_01C07964.B33A3240 Content-Type: application/ms-tnef; name="winmail.dat" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="winmail.dat" eJ8+IhETAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANEHAQAIAAsAEgAAAAEA/wAB A5AGAAgGAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB AAAAMwAAAGNvbm5lY3Rpb25zIHRocm91Z2h0IG9kYmMgdnMuIGluZm9ybWl4IDRnbCBwcm9ncmFt AAACAXEAAQAAABYAAAABwHmnwSHbvIV3arBLXpbDPnBBlxEKAAACAR0MAQAAABsAAABTTVRQOkpS VlRASU5GTy5SRUMuVUFCQy5NWAAACwABDgAAAABAAAYOAKTQtqd5wAECAQoOAQAAABgAAAAAAAAA yy6f3uVf0xG3XQCAyP0Xw8KAAAALAB8OAQAAAAIBCRABAAAAyAEAAMQBAACNAgAATFpGdVSg2ekD AAoAcmNwZzEyNSYyAPgLYG5nAdA1OE8B9wKkA+MCAGNoCsBzsGV0MCAHEwKAfQqA2QjIIDsJbw4w NQKACoGSdgiQd2sLgGQ0DGD2YwBQCwNjAEELtBTgCrFhCoAgSGkgB0ADIDpDFkQWREFjdHUW4XkI IEkgEPB2ZSB0aHdvIBEgchjAERAsfiACIBjQAhAFwAuAGgFtjGl4FtAUwCA0ZwMgZnADYAnAYW0Z kRrSdHpoGNBvHDEFwBoPBaBuexnQGABpAiAEIBwwA2B1jGdoBUAEcGJjLhZEExiAGQB1bBrwbGlr 3xjRGRAQ4Q8gGNFoBAAZIP8cQADAGaAWwAeAA5EiASBmfxijGcIZNBzDAQAYwAkAcF8HgAIwG+8F wBtRZBUAY1MeUR91YnUlEW0iAW5/HHAZIAhwGNABoAhgBUBo+m8H4GMDkQdwCrAYABwj7nAEkBpi AHBjGNAGkCIBfwWgBtALgBjQHe8e9h2fdPZyKOAe42kbGxZEKSIAcJp5BuBkGGAcQGxwIiHMID8X OgrzIEoFsCEhdlYHQAnwegpQC2AWRESEQkExylVBQkMfdQUR4QA1wAsAAIAIIAYAAAAAAMAAAAAA AABGAAAAAAOFAAAAAAAAAwAEgAggBgAAAAAAwAAAAAAAAEYAAAAAUoUAACdqAQAeAAWACCAGAAAA AADAAAAAAAAARgAAAABUhQAAAQAAAAQAAAA5LjAAAwAGgAggBgAAAAAAwAAAAAAAAEYAAAAAAYUA AAAAAAALAA+ACCAGAAAAAADAAAAAAAAARgAAAAAOhQAAAAAAAAMAEIAIIAYAAAAAAMAAAAAAAABG AAAAABCFAAAAAAAAAwARgAggBgAAAAAAwAAAAAAAAEYAAAAAEYUAAAAAAAADABSACCAGAAAAAADA AAAAAAAARgAAAAAYhQAAAAAAAB4AJIAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAA AAAeACWACCAGAAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgAmgAggBgAAAAAAwAAA AAAAAEYAAAAAOIUAAAEAAAABAAAAAAAAAAsAN4AIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAA CwCRgAggBgAAAAAAwAAAAAAAAEYAAAAABoUAAAAAAAACAfgPAQAAABAAAADLLp/e5V/TEbddAIDI /RfDAgH6DwEAAAAQAAAAyy6f3uVf0xG3XQCAyP0XwwIB+w8BAAAAUAAAAAAAAAA4obsQBeUQGqG7 CAArKlbCAABQU1RQUlguRExMAAAAAAAAAABOSVRB+b+4AQCqADfZbgAAAEM6XFdJTkRPV1Ncb3V0 bG9vay5wc3QAAwD+DwUAAAADAA00/TcAAAIBfwABAAAANQAAADxOREJCTEhGTk1MS09GSENEUENK TUFFQUVDREFBLmpydnRAaW5mby5yZWMudWFiYy5teD4AAAAAAwAGEHYCGY4DAAcQXQEAAAMAEBAA AAAAAwAREAEAAAAeAAgQAQAAAGUAAABISUFMTDpBQ1RVQUxMWUlIQVZFVFdPU0VSVkVSUyxPTkVG T1JJTkZPUk1JWEFORDRHTFBST0dSQU1TLEFORFRIRU9USEVSRk9SSU5GT1JNSVhBTkRDT05ORUNU SU9OU1RIUk9VAAAAAAZD ------=_NextPart_000_0008_01C07964.B33A3240--
"Lic. Jorge Valenzuela" wrote: > This is a multi-part message in MIME format. Please don't post MIME messages! > Actually I have two servers, one for informix and 4gl programs, and the > other for informix and connections throught odbc. > I would like to change this shema, i mean i like to have one server for > development and the other for produccion. > but am i not sure about how can impact the performance if i combine > connections throught odbc and connections trhought i4gl programs, > can anybody help me ? There is no specific conflict between the ODBC connections and the I4GL (ESQL/C) connections. The only problem is the increased workload from having the single production machine handle the workload that two machines were previously sharing. -- Jonathan Leffler (jleffler@earthlink.net, jleffler@informix.com) Guardian of DBD::Informix 1.00.PC1 -- see http://www.cpan.org/ #include <disclaimer.h>
Related threads
- Conversion to differeent characters sets
- Problem in changing locale via dbexport/dbimport
- RE: openlink error "Unable to load locale categories"