Let's see...
Typical data sets average about 100K records for a single day.
In most cases I have to use all records for a given day and I've had the DBA's create temp tables to hold the daily records. My sql then is basically 'select *'. Temp tables are dropped and created each day. This is...
iberian,
Not linking CR to Access.. CR to Oracle 8i
Changed to native driver yesterday (once I figured out what it was) and still see no real improvement? I think I just have a whole lot of data and not very fast machines...?
At least that seems to be the concensus...
Thanks
Iberian,
Your Crystal Reports comment caught my eye.
I use Crystal Reports on an IIS web server to query Oracle db. Users on corp intranet use Crystal's web server component to run reports and get results returned to their browser via ActiveX. Problem is the speed. I'm using Oracle ODBC driver...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.