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:
FTP and [shell] (2003)
Car Database (2002)
passing search criteria (1997)
remotely creating and populating a stock inventory db -almost there! (1999)
unable to launch acgi in WebCat (1997)
FREE Stuff .. (2003)
Unexpected error (1997)
Wanted: More Math Functions (or, Can You Solve This?) (1997)
WebCat Code and WebStar Search? (2000)
Tax only sometimes (2002)
WebCat2 - Getting to the browser's username/password data (1997)
no template caching (1997)
Friendly , quick 'security' check, please (2003)
Templates for sale (2001)
form data submission get (1997)
For those of you not on the WebCatalog Beta... (1997)
Semi OT: IE losing info from forms when back button is used (2005)
problems with 2 tags (1997)
[protect] and identification (2008)
WebCatalog Hosting (1996)