Accessing the data is kind-of slow here

From: Martin Pein <martin.pein_at_fernuni-hagen.de>
Date: Tue, 30 Apr 2002 09:38:29 +0200
Message-ID: <aalhi6$4ud$1@beech.fernuni-hagen.de>

Hi there,

I've got a generated table here (in an Oracla 8 db) with about 400 columns and about 4000 sets. About 95% of the fields are empty. One of the columns is a unique and indexed and not-null'd ID.

Accessing the data is kind-of slow: a "select count(*)" takes about 5 seconds.
It also takes about 5 seconds for a "select id from .. where id=17" to return with the result (17 :-). The same is basically true for the other fields in the row.

All the other tables with fewer columns are much quicker. From you experience, is that likely to be an architectural or a technical problem?

Thanks,

Martin Received on Tue Apr 30 2002 - 02:38:29 CDT