Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

Speed up app using sql server on Xeon 3.0s

I run an app on a citrix box which is a Dual Xeon 3.0 w/ 3 gigs and a 1 gb network card; it talks to a similiarly configured SQL server, that only runs SQL.  I am running Windows 2000 server on both boxes.

It loads a patient with a lot of activity in 30 seconds.  Normal patients, without as much activity load in 8 seconds.  Part of the time is spent rendering a graphical
dental chart (about 2 seconds) and it loads the roughly data twice from sql - once to draw the chart and then again to display the text.

Anyway, if I throw an opteron or athalon at this, does anyone think I can approach speeding this up by a factor of 2?

Other than hardware, I am going to investigate optimizing the sql database.  I called the application company and they said, "yeah, that patient has a lot of data".

I am thinking, man, sql should scale beyond a 2 gig database for 20,000 patients, one of whom has maybe 1000 entries to call up in their account!

When I write a query to get everything the database holds on the patient, I get it all back in less than a second.  But when you look at sql profiler as the app gets it back, it is sending about 500 individual select statements.  I was told, using many "small" select statements prevents the database from slowing down for other users but may make an individual request, like a patient with a lot of data to pull slower.

thanks,

-gsgi
0
gsgi
Asked:
gsgi
  • 2
1 Solution
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>Anyway, if I throw an opteron or athalon at this, does anyone think I can approach speeding this up by a factor of 2?
no. I actually think you won't get hardly any change at all.

>But when you look at sql profiler as the app gets it back, it is sending about 500 individual select statements
not really efficient

>I was told, using many "small" select statements prevents the database from slowing down for other users
well, if you have a BIG report with thousands of rows, well this can apply.
for a single entity and it's related records, up to 1000 entries, this should be in 1-2 seconds (for the query) including displaying the text data, then 1-2 seconds or even more for rendering the graphics (without querying the data again of course).

0
 
gsgiAuthor Commented:
Yes the same application ran as an ISAM database and pulled the same patient in 6 seconds.

I have another client with a Xeon 2.4 Citrix box, and a Dual Xeon 2.8 as the SQL server.  I feel it runs basically like the 2 dual 3.0 xeon config.
So if we see no speed up between from xeon 2.4 to xeon 2.8, your probably right that going to an athalon 4400 wouldn't matter.

It did seem to run faster at a place that had a dell 6000 quad machine running, but I obviously couldn't call up this patient while I was there,
and that box was like 8K.

So you feel that the only real approach to this is to convince the application writer to speed it up.

By the way, as I was looking at opteron servers, I noticed the Intel 1000 MT is $99 and the Intel 1000 FX is $499.  Can you explain why the difference.

Thanks,

-gsgi
0
 
Guy Hengel [angelIII / a3]Billing EngineerCommented:
>By the way, as I was looking at opteron servers, I noticed the Intel 1000 MT is $99 and the Intel 1000 FX is $499.  Can you explain why the difference.
that's not my strong point, sorry

>So you feel that the only real approach to this is to convince the application writer to speed it up.
well, my latest project was speeding up an existing application.
it was about "printing" invoices (ie generate the ps and pdf) files.

before:
it run in 4 machines x 7 batches (processes), and it took ~24 hours to complete

I rewrote (took me 2 weeks), here the results:
it run on 3 machines x 7 batches, and it took less than 3 hours to complete
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now