Site Menu
- Home
- Products
- NexusDB
- Nexus Quality Suite
- NexusDB Drivers & Connectors
- Nexus Remoting
- Nexus Memory Manager
- Some of our Customers
- Testimonials and use(r)s
- Downloads
- Documentation
- Support
- Pricing & Orders
- About
- Community
- My Nexus
- Recently Updated ...
- Search...
- Site Login
Search
Why are SQL filter so much slower than an actual SQL query?
If a filter is applied to a 10,000,000 row table and returns 10 rows, it won't be instantaneous because NexusDb will process all 10,000,000 rows looking for the 10 that satifies the filter. This is sloooowwwww. Why?
That is, by definition, the fundamental difference between a table and a query. Query's pre-process and return result sets. Table's are direct cursors into the data for navigational data access.
Questions? Problems?
- Interested to buy but something put you off?
- Can't find what you're looking for?
- Have a suggestion?
Let us know. If you're having trouble contacting us, please check here.
1x | The Full Monty Pack | AUD 1,800.00 |
1 Item | Total: AUD 1,800.00 |
(View cart) (Checkout) |
Site Updates
- Dec 4 2024 - 1:53pm
- Dec 4 2024 - 1:48pm
- Nov 19 2024 - 1:04pm
- Oct 17 2024 - 10:27am
- Jul 24 2024 - 1:22pm