Icon View Thread

The following is the text of the current message along with any replies.
Messages 1 to 3 of 3 total
Thread Optimize code for SQL-server or file access server
Fri, Feb 29 2008 11:06 AMPermanent Link

QuickAndDirty
Hello,
I'm implementing an addational abstractionlayer between our TDataset descandent and
several other TDataset descandants including the ElevateDb Components.
Our application contains codes that are optimized for SQL-servers(MS-SQL/Oracle) and for
file based Databases (Paradox/BDE), actually.
On application start, the kind of database(SQL or file based) that is used is detected, so
that the optimzed code can be used.

Is ElevateDB more a SQL-Server or more a Filebased Database?

At the moment I think of it to be file based Database if used in local mode.
But what if it is used in remote mode?
What would TEDBTable.open do, 'Select * '  ?

Mon, Mar 3 2008 7:01 AMPermanent Link

Tim Young [Elevate Software]

Elevate Software, Inc.

Avatar

Email timyoung@elevatesoft.com


<< Is ElevateDB more a SQL-Server or more a Filebased Database? >>

It's both.

<< At the moment I think of it to be file based Database if used in local
mode. But what if it is used in remote mode? >>

Same situation.

<< What would TEDBTable.open do, 'Select * '  ?  >>

No, it only retrieves the rows necessary to satisfy any data-aware controls,
or the value of the RemoteReadSize property:

http://www.elevatesoft.com/scripts/manual.dll?action=mancompprop&id=edb1&product=d&version=7&comp=TEDBDataSet&prop=RemoteReadSize

whichever is greatest.

--
Tim Young
Elevate Software
www.elevatesoft.com

Fri, Mar 28 2008 1:01 PMPermanent Link

Martin Ludwig
Thanks, for this detailed Information.
Image