?
Solved

Paradox: filters versus queries

Posted on 2002-04-13
4
Medium Priority
?
232 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
4 Comments
 
LVL 15

Accepted Solution

by:
simonet earned 300 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

Want to be a Web Developer? Get Certified Today!

Enroll in the Certified Web Development Professional course package to learn HTML, Javascript, and PHP. Build a solid foundation to work toward your dream job!

Question has a verified solution.

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

A lot of questions regard threads in Delphi.   One of the more specific questions is how to show progress of the thread.   Updating a progressbar from inside a thread is a mistake. A solution to this would be to send a synchronized message to the…
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…
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…
How to fix incompatible JVM issue while installing Eclipse While installing Eclipse in windows, got one error like above and unable to proceed with the installation. This video describes how to successfully install Eclipse. How to solve incompa…
Suggested Courses

762 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