Q? Do rowsets cache ??

Thread View: borland.public.intrabuilder.data.sql

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Steven Ensslen Wed, 28 Jan 1998 00:00

#43

Author: 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)

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads