 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Andrew Gabb
Guest
|
 Posted: Tue Aug 08, 2006 7:44 am Post subject: Speed issues: Paradox vs MS SQL Server |
 |
|
How is speed likely to vary using MS SQL Server as opposed to
Paradox for the same DB on a Windows network.
I'm only looking for a rough idea, particularly for displaying full
sorted lists of say 50,000 items.
Andrew
--
Andrew Gabb
email: agabb (AT) tpgi (DOT) com.au Adelaide, South Australia
phone: +61 8 8342-1021
----- |
|
| Back to top |
|
 |
Wayne Niddery [TeamB]
Guest
|
| Posted: Tue Aug 08, 2006 7:22 pm Post subject: Re: Speed issues: Paradox vs MS SQL Server |
|
|
Andrew Gabb wrote:
| Quote: | How is speed likely to vary using MS SQL Server as opposed to
Paradox for the same DB on a Windows network.
I'm only looking for a rough idea, particularly for displaying full
sorted lists of say 50,000 items.
|
There are two separate issues here. One is how to compare such completely
different products, and the other is the issue of displaying so many records
to the user.
1. Trying to compare depends on lots of things - is the client on same
computer as database server or across the network? How many *concurrent*
users are accessing that database (all requesting 50,000 records across that
network!). How well normalized are the data tables and how well are they
indexed?
But no matter the answers to the above questions, the fact is that using
database servers requires a different design than can be used with desktop
databases, you simply cannot do things the same way and hope to get
satisfactory results.
2. Please read these:
Tables vs. Query Components:
http://blogs.teamb.com/wayneniddery/articles/400.aspx
Browsing Large Volumes of Data:
http://blogs.teamb.com/wayneniddery/articles/401.aspx
--
Wayne Niddery - Winwright, Inc (www.winwright.ca)
"If there is any principle of the Constitution that more imperatively
calls for attachment than any other, it is the principle of free
thought - not free thought for those who agree with us, but freedom for
the thought that we hate." - Oliver Wendell Holmes |
|
| Back to top |
|
|
Brian Bushay TeamB
Guest
|
| Posted: Thu Aug 10, 2006 6:12 am Post subject: Re: Speed issues: Paradox vs MS SQL Server |
|
|
| Quote: | How is speed likely to vary using MS SQL Server as opposed to
Paradox for the same DB on a Windows network.
I'm only looking for a rough idea, particularly for displaying full
sorted lists of say 50,000 items.
|
SQL servers are efficient at quickly returning a small number of records but no
in returning large datasets. Paradox will be faster at a 50,000 record return.
But that is way more records than someone can effectively scroll through.
If you provide an interface for the user to enter some selection criteria so
they can get just the records they want SQL server will be faster.
--
Brian Bushay (TeamB)
Bbushay (AT) NMPLS (DOT) com |
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
