PerformanceQuestion

[Ruslan Zasukhin]

On 2/26/05 6:22 PM, "Claudius Sailer" <Claudius at sailer-online.de> wrote:

> 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!!

I think the first way is better.

And have you note in 2.0 the best way for this task:


  res = tblKonten.Field("Konto_Typ").ValueExists( 1 )


This is the BEST POSSIBLE step, Claudius.

-- 
Best regards,
Ruslan Zasukhin      [ I feel the need...the need for speed ]
-------------------------------------------------------------
e-mail: ruslan at paradigmasoft.com
web: http://www.paradigmasoft.com

To subscribe to the Valentina mail list go to:
http://lists.macserve.net/mailman/listinfo/valentina
-------------------------------------------------------------