Re: sqlreportwriter question
From: Paul Dorsey <pdorsey_at_dulcian.com>
Date: Wed, 23 Jun 1999 02:04:49 GMT
Message-ID: <5hXb3.26833$eF3.10110_at_news.rdc1.nj.home.com>
Date: Wed, 23 Jun 1999 02:04:49 GMT
Message-ID: <5hXb3.26833$eF3.10110_at_news.rdc1.nj.home.com>
A cursor is a cursor.
Where I have seen this is when the report is written badly.
List everything that is different between the old and the new system.
-- Paul Dorsey Dulcian, Inc. www.dulcian.com 212 595 7223 Joe Pitt wrote in message ...Received on Wed Jun 23 1999 - 04:04:49 CEST
>We are currently upgrading a system from Oracle6 to a dual-server Oracle7
>environment. This system needs SQL*FORMS, so we will have one machine (VAX
>running OpenVMS v5.5) with Oracle v7.1.5 - to support the applications
>(sqlforms, sqlreportwriter, etc.) The main database is on another VAX
>running OpenVMS 6.2 and Oracle v7.3. We are using public synonyms with a
>dblink to go from application server to database server.
>
>Now for the question... SQLFORMS and SQLPLUS seem to be working fine - but,
>while SQLREPORTWRITER is working, it is incredibly slow. A report in the
old
>environment (everything on one server) took 15-20 seconds - in the new
>environment it takes more like 15-20 minutes. Anyone ever run across this
>type of situation? Any ideas?
>
>[I installed sqlreportwriter to use central tables rather than each user
>having their own tables.]
>
>
>
>
>