By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
429,262 Members | 2,664 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 429,262 IT Pros & Developers. It's quick & easy.

SQL vs Btrieve

P: n/a
Hi, can someone help me out here. We have a database system for our
distribution department to ship out orders everyday. We code with Clarion
5.5 of Windows are implementing some SQL. The current code implemented is
working great. We want to add some more but our boss is having major
reservations about it. He thinks that it will tax the server too much.
Here is what we want to do. We have these production counts app that tells
the managers what orders are down for the day, what is printed or process
for the day and what is shipped for the day. It is also broke down by
carrier and order type. Now there is probably 10-15 units that will be
running these counts during the day. Currently we have it update
automatically every 5 minutes. Now there will be about 15 or so SQL
statements that will retrieve all the info we need. Now will this bog down
the server if this many clients are running it and it auto updates ?? I am
thinking no way. It is brand new server, windows 2000 with new 1.6 Ghz
clients. I can't see it taxing the server much to where we will see slow
downs.

The other way is using our Btrieve files and we have some count files that
we read and produce the counts.

Can anyone give me more information or where to read up on it ?? Thanks,
Clint
Jul 20 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.