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
howidaelrasheedAsked:
Who is Participating?
 
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
 
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
 
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
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.