Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Speed difference TDBISamQuery
Wed, Jun 13 2007 4:53 AMPermanent Link

"Ronald"
Hi,

I use version 3. Is there a diiference in speed if I execute a query with
TDBISamQuery on a table or the "real" serverversion of DBISam. Is the
diffence big?

Greetings,
Ronald
Wed, Jun 13 2007 2:40 PMPermanent Link

Dave Harrison
Ronald wrote:

> Hi,
>
> I use version 3. Is there a diiference in speed if I execute a query
> with TDBISamQuery on a table or the "real" serverversion of DBISam. Is
> the diffence big?
>
> Greetings,
> Ronald

Ronald,
    How amny people are using the data file at the same time? Is the
data on a local machine? If so, probably the LAN version will be faster.
If the data is on another machine then the C/S should be faster since it
is only transferring a small number of records compared to the LAN
version which transfers the whole file to the client.

Dave
Wed, Jun 13 2007 4:10 PMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com

Ronald,

<< I use version 3. Is there a diiference in speed if I execute a query with
TDBISamQuery on a table or the "real" serverversion of DBISam. Is the
diffence big? >>

Dave is correct.  Direct access works best when the tables are local, but
over a network the database server will be faster than direct execution.

--
Tim Young
Elevate Software
www.elevatesoft.com

Image