Article View: borland.public.intrabuilder.data.sql
Article #43Q? Do rowsets cache ??
From: Steven Ensslen
Date: Wed, 28 Jan 1998 00:00
Date: Wed, 28 Jan 1998 00:00
25 lines
1232 bytes
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-mailShow 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