Solved

Paradox: filters versus queries

Posted on 2002-04-13
4
226 Views
Last Modified: 2010-04-04
Hi all,

Is there a significant speed difference in filtering
a paradox table versus defining a query, using the BDE
and native paradox driver?

I'm wondering, as I have been using filtering extensively, but it really seems to start bogging down pretty quickly.

Any discussion appreciated.
0
Comment
Question by:oneeye
4 Comments
 
LVL 15

Accepted Solution

by:
simonet earned 100 total points
ID: 6939631
Yes... queries are always faster.

This is because Delphi has to create a query from the TTable component, and that itself is already some overhead to the application. Now, if there's a filter, then it's even more work.

If everything is already in a query, Delphi simply has to submit the query to the BDE and wait for the results. No overheads, no nothing.


Alex
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 6939785
depends if there is an index on the filtered field,
but usual a query is faster than a filter

meikl ;-)
0
 
LVL 9

Expert Comment

by:ITugay
ID: 6939880
Hi oneeye!

I agree with Alex and meikl, but there is another side of medal:

filtering works faster in case you open table once and then apply different filters few times. It similar to caching mechanizm, it works slow first time, but fast in further usage of the same data. So, it is depend from what you are going to do.

------
Igor.
0
 

Author Comment

by:oneeye
ID: 6940503
Okay,

Less overhead is good, I'll try a few queries and see if I see a performance improvement. Now I just have to review SQL.
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Delphi Firemonkey Need Sample for Online Shopping Example. 2 120
select query - oracle 16 95
can't find the executable in Simulator 1 80
CheckListBox usage 3 51
Have you ever had your Delphi form/application just hanging while waiting for data to load? This is the article to read if you want to learn some things about adding threads for data loading in the background. First, I'll setup a general applica…
Introduction Raise your hands if you were as upset with FireMonkey as I was when I discovered that there was no TListview.  I use TListView in almost all of my applications I've written, and I was not going to compromise by resorting to TStringGrid…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Learn how to create flexible layouts using relative units in CSS.  New relative units added in CSS3 include vw(viewports width), vh(viewports height), vmin(minimum of viewports height and width), and vmax (maximum of viewports height and width).

867 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now