Search 800.000 records... performance
-
Hi!
Days ago, i have seen a company pub claiming that their product can "querie/search over one million records taking less than 3 seconds!"...
I was wondering what technic do they use?
Whats the magik trick???
LabDev
labdev@iol.pt -
3 seconds? That is slow! We have several tables over 1 million records, and if we offered 3 seconds to our users, they'd show us the door. I have just ran a query on a 933 000 row table which returned data in less than 1 millisecond.
Performance comes down to a number of factors (to name a few):
- Index design
- How you code your SELECT, do you use the index optimally, do you have any data type converions or calculations, how many columns is your table (narrow tables offer better performance), sorting
- Server performance, esp. memory
-
I was wondering what technic do they use?
Whats the magik trick???
What's so magic about this anyway?
- Use a RDBMS
- Design a sound schema
- Create useful indexes
- Create sound queries
there you go
..btw, in some environments are 3 seconds considered relatively slow
--
Frank Kalis
Microsoft SQL Server MVP
Webmaster: http://www.insidesql.org/blogs
My blog: http://www.insidesql.org/blogs/frankkalis/[/url] -
ok, thanxs a lot
LabDev
labdev@iol.pt
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply