Re: Oracle paranoia in ODBC?

Absolute rubbish!

We have an application that is running on NT that quite happily will execute multiple queries against an Oracle733 server simultaneuosly without any problems at all. We tested over half a dozen simultaneous queries with CPU utilization at all times below 50%.

The application is now live and currently is being hit by requests from about 100+ users and doesnt break down.

There is nothing inherent in windows that prevents multiple simultaneous queries.

Rob

Jerry Gitomer wrote in message <35C1BB03.7869_at_ictgroup.com>...
>Hi,
>
> The problem is with windows -- not Oracle. Even with NT trying to run
>more than one query from the same PC is enough to lock up the "operating
>system". I gather that this is a flaw in the way windows handles
>communications between client and server.
>
> If you must run multiple queries on the same workstation you may have
>to switch to Unix and X-Windows. You can then open as many windows as
>you want and run a query in each.
>
>regards
>
>Jerry
>
>
>
>maxmike_at_ibx.bc.ca wrote:
>>
>> Oracle ODBC drivers don't support multiple connections. In fact if you
>> try it, the engine (or driver) hangs up (under Personal Oracle).
>>
>> This means if you have a program capable of letting the user run multiple
>> queries on the same workstation, it will be impossible even if the user
>> is running Enterprise edition servers. Wait till they hear about that at
>> corporate.
>>
>> Is anybody bypassing this with non-Oracle drivers? Which?
>> Thanks for any hints.
>>
>> -----== Posted via Deja News, The Leader in Internet Discussion ==-----
>> http://www.dejanews.com/rg_mkgrp.xp Create Your Own Free Member Forum
>
>--
>Jerry Gitomer ICT Group
>jgitomer_at_ictgroup.com Langhorne PA
>jgitomer_at_yahoo.com Opinions are mine not those of ICT Group
Received on Sat Aug 01 1998 - 23:07:38 CDT