# Fastest way to search in a dataitem

**URL:** <https://support.steema.com/t/fastest-way-to-search-in-a-dataitem/16264>\
**Category:** VCL\
**Created:** [December 14, 2017, 11:44am UTC](https://support.steema.com/t/fastest-way-to-search-in-a-dataitem/16264 "2017-12-14T11:44:23Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![uRoland80079](https://support.steema.com/letter_avatar_proxy/v4/letter/u/bcef8e/32.png) [@uRoland80079](https://support.steema.com/u/uRoland80079)\
**Post date:** [December 14, 2017, 11:44am UTC](https://support.steema.com/t/fastest-way-to-search-in-a-dataitem/16264/1 "2017-12-14T11:44:23Z")

</div>

Hello.  
Can you tell me, what is the fastest way to search for a specific dataitem value.  
Lets say I have invoices and invoice positions in a dataitem and want to find all invoiceppositions for invoice xy?  
Should I use filters or queries?  
Or is any of the possibilites as fast as the other?

Thanks.

---

<div class="post-metadata">

**Author:** ![Yeray](https://support.steema.com/user_avatar/support.steema.com/yeray/32/8920_2.png) [@Yeray](https://support.steema.com/u/Yeray)\
**Post date:** [December 18, 2017, 2:37pm UTC](https://support.steema.com/t/fastest-way-to-search-in-a-dataitem/16264/2 "2017-12-18T14:37:06Z")

</div>

Hello,

I’d use a Query with a Filter as in the [Speed example](https://github.com/Steema/BI/tree/master/demos/delphi/vcl/Speed):

```plaintext
procedure TBISpeedTest.SQL1_Proc;
var Query : TDataSelect;
    Alex : TDataItem;
begin
  Query:=TDataSelect.Create(nil);
  try
    Query.Add(Persons); // * all fields

    Query.Filter:=TDataFilter.FromString(Persons,'Name="Alex"');

    // Execute Query and after that, just destroy results
    Alex:=Query.Calculate;
    Alex.Free;

  finally
    Query.Free;
  end;
end;

```

---

<div class="post-metadata">

**Author:** ![uRoland80079](https://support.steema.com/letter_avatar_proxy/v4/letter/u/bcef8e/32.png) [@uRoland80079](https://support.steema.com/u/uRoland80079)\
**Post date:** [December 18, 2017, 2:41pm UTC](https://support.steema.com/t/fastest-way-to-search-in-a-dataitem/16264/3 "2017-12-18T14:41:06Z")

</div>

Ok.  
Thanks Yeray.