• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 203
  • Last Modified:

How to cache whole data into server memory

Hi All,
i have adatabase written in SQL Server 2000 and i want to increase its performance by reducing I/O disk requests by finding a method(s) to load the whole data into memory so as the application need not to request the disk for not found tuples. could anyone help me pls its urgent i have posted this question in c++ and java and i didn't found a n answer .
it is critical for me to do this job so pls give me help.
thanks
0
howidaelrasheed
Asked:
howidaelrasheed
  • 4
  • 4
  • 2
  • +3
2 Solutions
 
TheRealLokiSenior DeveloperCommented:
You could use a RamDrive, and assign it a drive letter, e.g. R: copy your database to that on startup, and from that point on, it is all really using ram
0
 
BlackTigerXCommented:
what are you using? Delphi for .NET?

in that case you just use ViewState, Session or Application state

here's an example using the Session state

var
sqlComm:SqlCommand;
ds:DataSet;
da:SqlDataAdapter;
begin
  sqlComm:=SqlCommand.Create();
  sqlComm:=SqlConnection.Create(ConnectionString)
  sqlComm.CommandType:=CommandType.StoredProcedure;
  sqlComm.commandText:='spGetOffices';
  ds:=DataSet.Create();
  da:=SqlDataAdapter.Create(sqlComm)
  da.Fill(ds);
  Session["Offices"] = ds; //save the dataset so it can be used throughout the whole application
end;
0
 
BigRatCommented:
A strange question, if I might say so, why SQL 2K cannot effectively buffer using the entire memory available is beyond me. Windows knows no quota, so after a while all indexes must lie in main memory.

Is the problem (of not found tuples) caused by a lack of an index or a compilcated join?
0
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.

 
pcsentinelCommented:
After open simply go Last then First, this should cache your data
0
 
howidaelrasheedAuthor Commented:
I want to deifne another method to increase SQL Server 2000 performance I mean in Addition to its facilities  and say that i follow up the traditional ways that provided by SQL Server 2000 to tune my database. I am using Delphi 6 not .Net
0
 
pcsentinelCommented:
Please explain your last comment a little more

0
 
BigRatCommented:
>>I want to deifne another method to increase SQL Server 2000 performance.

I have a customer who uses a Raid-5 disk array with a 100MB cache. Early in the morning a small C program reads the database files block by block. The effect is that the entire database ends up in the cache.
0
 
cwwkieCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Delete - No Refund

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

cwwkie
EE Cleanup Volunteer
0
 
BigRatCommented:
>>Delete - No Refund

There is some advice which actually does answer the question. A minimum should be to PAQ. Whose advice was taken I do not know, which is why I did not comment.
0
 
cwwkieCommented:
My recommendation was delete because according to http:#13734100 the asker was not happy with the answers so far. And the raid array cache is only possible if the database size is smaller than the cache size, (and if you can afford such a raid).

But tell me what you suggest,
   PAQ - No Refund is no solutions, because it will mean at least one of the answers is usefull, and that should get points.
   And I also do not want to split among everybody who has participated.

If you tell me which answers are the most usefull, and nobody else objects, I can change my recommendation.
0
 
BigRatCommented:
The first question with abandoned questions should be : has it any value in the PAQ database. I think inspite of the questioner's reservation (into which he did not elaborate) it has. There were several suggestions. It may be that this is a kiddies question, but I tend to assume the questioner is a professional where the cost of a RAID is really not a factor.

Therefore I'd PAQ instead of delete.

Now onto the cheese. If you don't want to split then you must find the best answer. If you can't decide then allocate no points. I can't tell you which is most useful without compromising myself or assuming something about the questioner.

Lastly because this is an abandoned question, the points should be forfeited if they are not allocated.

I hope that helps :)
0
 
cwwkieCommented:
Ok, then I think I will suggest a split between one server-side suggestion and one client-side suggestion.
0
 
cwwkieCommented:
No comment has been added to this question in more than 21 days, so it is now classified as abandoned.

I will leave the following recommendation for this question in the Cleanup topic area:
   Split: BlackTigerX {http:#13724046} & BigRat {http:#13735023}

Any objections should be posted here in the next 4 days. After that time, the question will be closed.

cwwkie
EE Cleanup Volunteer
0

Featured Post

Keep up with what's happening at Experts Exchange!

Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.

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