try reorganization the table .
"Percival Boqais" <pb_at_microsoft.com> ¼¶¼g©ó¶l¥ó·s»D
:MEts8.6055$DQ6.1211196544_at_newssvr15.news.prodigy.com...
> Trying to figure out a problem. I am a programmer, trying to help the
DBA.
> We have IIS 4, ASP code talking to a VB DLL. The VB DLL then runs queries
> against an Oracle database and brings back the data to the ASP page via
pipe
> delimited strings.
>
> We have one particular query which is actually using a view repeated
times,
> in the DLL. In other words, it brings back a list of Projects from the
DB,
> then calls the view to determine the Tasks (sub-level) and ETC on each
task.
> The view accesses about eight or nine tables. The table with the most
> records by far has roughly 70,000 records. The rest of the tables have
less
> than 2,000 records.
>
> Recently, this view started running very slowly. I don't know what went
on
> at the database side of things, but it's slow. I ruled ouf the web
server,
> as I accessed the DLL directly via a VB sandbox, it was slow there too.
The
> view consists of joins. Granted, on the 70,000 record table, there aren't
> indexes where they should be, but it's always been like that, even before
> things slowed down. As of last Thursday, the view which used to be fairly
> snappy, is now slow.
>
> I would say every week, 2-3,000 records are added to the 70,000 record
> table. I'm just wondering if there is some sort of limit that's been hit,
> or quota reached (tablespace?). I don't know as I'm not a DBA. Does
anyone
> else know why this would slow down? Sorry for the lack of details.
>
> ~ PB
>
>
Received on Tue Apr 09 2002 - 01:17:08 CDT
