🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.intrabuilder.data.sql
Article #43

Q? Do rowsets cache ??

#43
From: Steven Ensslen
Date: Wed, 28 Jan 1998 00:00
25 lines
1232 bytes

	Hi all,

	I've always been curious as to why my oracle database needs so little cpu
time while my intrabuilder agents (IB 1.5) need so much.  I've come up with
a rather distrubing theory.

	Which of the following happens if I have a rowset open and I "locate" a
specific row.

	A).  A SQL query is built for the parameters used in the locate, and this
query is issued against my database.

	B) Intrabuilder keeps a cached copy of my entire table in its innerds, and
searches this cache to find the rows that I'm trying to "locate".

	The manual says that open rowsets have data cached, but intrabuilder would
refresh the rowset instead of searching its own.  Right?

	Finally, If B is true, is there any way to make intrabuilder use the
database for searching??

	Steven Ensslen
	(steven@fifthd.ca)
Technical Details
Message-ID: <01bd2c2a$bdb44b00$6657a1c6@maudite.fifthd.ca>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,9bc9885b78ac6af8,start
X-Google-Attributes: gid101d9a,public
From: "Steven Ensslen" <steven@fifthd.ca>
Subject: Q? Do rowsets cache ??
Date: 1998/01/28
Message-ID: <01bd2c2a$bdb44b00$6657a1c6@maudite.fifthd.ca>
X-Deja-AN: 320057454
Organization: Fifth Dimension Information System
Newsgroups: borland.public.intrabuilder.data.sql