ODBC Performance?
This WebDNA talk-list message is from 2001
It keeps the original formatting.
numero = 37343
interpreted = N
texte = Hey,I am having a serious performance problem with WebCatalog 4 connecting to an Oracle 8 database through the Windows ODBC control panel.The config as it stands is: Windows 2000 IIS 5 Oracle 8.1.7 WebCatalog 4.0.2rc1I am doing a nested search to the Oracle database, and there are only 50 items in the table, but it is taking 40 seconds to display the results.I checked the Performance Monitor- the search is only taking 20-30% of the processor on the WebCatalog box.The Oracle database is on another box. The connection is 100mbps Ethernet.I know that the same search done with a flat file takes about a second.Is it possible that the connection to the Oracle server through the ODBC interface could be throttled down in any way, or in oracle itself?And no, I can't just stick with the flat file. . .it all must be done with Oracle. Thanks in Advance. . .Rob ---------------------------------------------------------------- Rob Blair Manager of Web Technology ICSDNA, LLC. Post Office Box 75501 Colorado Springs, Colorado 80970-5501 rblair@icsdna.com Home 719.579.9442 AIM- roblair1 Cell 719.930.9571 WAP & HTTP: www.icsdna.com FAX 208.485.0397 Lat: 38.769719 Lon: -104.799829 --------------------------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list
. To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Associated Messages, from the most recent to the oldest:
Hey,I am having a serious performance problem with WebCatalog 4 connecting to an Oracle 8 database through the Windows ODBC control panel.The config as it stands is: Windows 2000 IIS 5 Oracle 8.1.7 WebCatalog 4.0.2rc1I am doing a nested search to the Oracle database, and there are only 50 items in the table, but it is taking 40 seconds to display the results.I checked the Performance Monitor- the search is only taking 20-30% of the processor on the WebCatalog box.The Oracle database is on another box. The connection is 100mbps Ethernet.I know that the same search done with a flat file takes about a second.Is it possible that the connection to the Oracle server through the ODBC interface could be throttled down in any way, or in oracle itself?And no, I can't just stick with the flat file. . .it all must be done with Oracle. Thanks in Advance. . .Rob ---------------------------------------------------------------- Rob Blair Manager of Web Technology ICSDNA, LLC. Post Office Box 75501 Colorado Springs, Colorado 80970-5501 rblair@icsdna.com Home 719.579.9442 AIM- roblair1 Cell 719.930.9571 WAP & HTTP: www.icsdna.com FAX 208.485.0397 Lat: 38.769719 Lon: -104.799829 --------------------------------------------------------------- ------------------------------------------------------------- This message is sent to you because you are subscribed to the mailing list . To unsubscribe, E-mail to: To switch to the DIGEST mode, E-mail to Web Archive of this list is at: http://search.smithmicro.com/
Rob Blair
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
(OT) Dual 2GHz G5 (2003)
creative use of webcatalog (1998)
MATH PROBLEM (1997)
Exclamation point (1997)
company names not begin with a letter (2005)
More on EudoraPro Email (1998)
Limit on nested [ShowIf]'s? (1997)
Friday night shopping site joke (1997)
install on redhat (2004)
Searching/sorting dates (1997)
Bad File: DeleteCommand.html (1998)
Not really WebCat (1997)
fieldType=num (1997)
Re:Dumb Question about Docs (1997)
WebMerchant 2.1.2 (1998)
[returnraw] and form variables (1998)
RE: format problem on NT? (1997)
WebCatalog Features (1997)
[input] [/input] (1997)
Trouble with formula.db + more explanation (1997)