Re: Oracle / MS-Access and SQL
Date: 1996/01/12
Message-ID: <4d5gj7$vab_at_duvi.eskom.co.za>#1/1
In article <4d0sq5$qef_at_crl5.crl.com>, xeus_at_crl.com (Stephen Custer) wrote:
>
>I'm going to be doing some work for a company that has Oracle 7.1.3
>running on a HP 9000. Their LAN is a Novell Netware set-up. They have a
>ODBC driver installed.
>
>Presently, they have a Access database that users access for reporting
>purposes. All of the existing Access queries are based on snapshots of
>Oracle tables and they create new tables to run the reports off of. Not
>very client server.
>
>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
It depends on various factors, but if you have a lot of data (50 000 + records), my experience is that the queries to Oracle is faster than querying tables lying on a Novell server, and it gets even faster the more data you have (compared to Novell).
As I said, there are a lot of factors that influence this statement (how busy is the LAN, how is Oracle set up, what does the queries do etc. etc.), but this is the general case.
Johan Received on Fri Jan 12 1996 - 00:00:00 CET