<No Subject Supplied>
>From naomi Wed Jul 7 15:39:40 MST 1993 remote from qip
From: naomi@qip (Naomi Walker)
Message-Id: <9307072239.AA22883@qip>
Received: from qip by misty.anasazi.com; Wed, 7 Jul 93 15:39:42 MST
Received: by qip (5.61/1.2)
(from naomi (Naomi Walker) to informix-list@rmy.emory.edu)
id AA22883; Wed, 7 Jul 93 15:39:40 -0700
Subject: Re: Lock types
To: informix-list@rmy.emory.edu (Informix List)
Date: Wed, 7 Jul 93 15:39:40 MST
In-Reply-To: <1993Jul7.171246.24370@pyra.co.uk>; from "Graeme Sargent" at Jul 7, 93 5:12 pm
X-Mailer: ELM [version 2.3 PL11]
Content-Type: text
Content-Length: 873
> >I tried to to select the count of the number of rows in a table this
> >afternoon and I received a message from ISQL that the table was locked. I
> >ran 'tbstat -k' and received the following:
>
> Alternatively, if you don't actually need Committed Read isolation, just
> SET ISOLATION TO DIRTY READ, and it will work fine.>
> graeme
> --
The problem I have with setting ISOLATION is that it affects the entire
database, and sometimes I only want a particular table. A silly thought
though. To get the number of rows in a table, sometimes I :
SELECT nrows
FROM systables
WHERE tabname = "table_name";
Its much faster than count(*).
--
Naomi Walker (aka N7FSA) naomi@anasazi.com
Phoenix, Arizona
To get the full value of joy,
you must have someone to divide it with. ---Mark Twain