Re: Oracle / MS-Access and SQL
From: <stanl_at_nando.net>
Date: 1996/01/13
Message-ID: <NEWTNews.821568996.31714.stanl_at_stanl.nando.net>#1/1
Date: 1996/01/13
Message-ID: <NEWTNews.821568996.31714.stanl_at_stanl.nando.net>#1/1
> Are pass-through SQL queries exceedingly slow? The previous developer
> indicated that it is faster to make a table on a local network drive, and
> then run queries against it.
>
> I'll test this theory next week, but I would be interested in any
> comments on this topic.
>
> Thanks!
>
> Steve
I don't think its the case that the queries actually run that slow, but ODBC must first request the entire Oracle schema and time is consumed here. Also, if you are not using Netware 4x, and your Oracle database is fairly sophisticated, you put a lot of demand on the single processor in Netware.
stan littlefield
bti
Received on Sat Jan 13 1996 - 00:00:00 CET