Filters. What is more efficient and quick

[ziclope]

Hello,

I would like know what is the best method for filter in Query statement.
I dont know how filter and filtered properties are working.

What is the 2 (any more ? ways is more quick:

1.- Way: use filter property

MyQuery->Close();

MyQuery->Filter = Key + " = " + Value;
MyQuery->Filtered = true;

MyQuery->Open();

2.- Way: Rewrite the SQL query.

MyQuery->Close();

MyQuery->SQL->Text = "SELECT * FROM mytable WHERE Key = Value";

MyQuery->Open();

Regards

[GEswin]

Writing SQL sentence is best performance

[Antaeus]

Both ways to filter recordset ziclope has offered are dependent on various conditionals. So you should test these ways yourself in your situation to choose the best.