PerformanceQuestion

[Claudius Sailer]

Hi,

I am using following coding to check, whether datas are in an table

   SQLString="SELECT RecID FROM Konten WHERE Konto_Typ=1"
   CurCheck= meineDatenbank.SQLselect(SQLString, 
EVCursorLocation.kServerSide, EVLockType.kNoLocks, 
EVCursorDirection.kRandom)
   Ende=CurCheck.RecordCount

is it faster to do it other way? e.g.

   SQLString="SELECT count(*) FROM Konten WHERE Konto_Typ=1"
   CurCheck= meineDatenbank.SQLselect(SQLString, 
EVCursorLocation.kServerSide, EVLockType.kNoLocks, 
EVCursorDirection.kRandom)
   res=CurCheck.firstRecord
   Number=field(1).value


Thanks for help and ideas!!


Claudius

-- 
G4/733 QS / MacOS X 10.3.7de / RB 5.5.3de/ Valentina 1.10.0 & 2.0bX
Homepage	http://www.ClaSai.de
iChat		ryhoruk
RealBasic ListBoxes: [ I feel the need...the need for speed!!! ]