Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations biv343 on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Ram Disk

Status
Not open for further replies.

tedsmith

Programmer
Nov 23, 2000
1,762
AU
Remember the old days of Windows98?
You used to be able to create a Ram Disk that preformed with Visual Basic just like a hard disk but much faster.
Is there a way of creating a ram disk that will work with VB in Windows XP & Win7 with Sata disks?
Does FAT32 or NTFS apply?

The app I am currently working on will receive a stream of up to 2000 passenger bus locations each minute from GPS android type devices in each bus (that's 33 each second).

I have a database that contains say 20 way points along each route and the start time of each run.
As each GPS location and vehicle ID is received I want to check if each bus is on schedule or not from the database. I then write a value in a 'Punctuality' column of another table against each bus ID, minus if early and plus if late.

That way I can see at any time which bus in every route in progress is on time or not. This is fed to a network of passenger information signs.

I can do each operation needed in only a few milliseconds each but to avoid the disk thrashing itself to pieces, a ram disk would be much better
 
What type of database are you using? Most modern databases have the ability to cache data in memory and only go to disk for writes. If there is enough RAM, the data will be loaded in to memory and your physical reads should actually be quite small.

I wrote a similar application involving GPS's and school buses. The vehicle positions were updated every 10 seconds with hundreds of vehicles running around. I wrote a VB6 application to get the data from the devices (base station hardware and/or web service). The VB6 application simply passed the data along to a SQL Server stored procedure that did all of the processing. The database was easily able to keep up. I even has a "reverse geocode" algorithm thrown in there (looking up a street name & house number based on the latitude/longitude coordinates).

Anyway, my point is... if all of your disk access is handled through a modern database, there should be no need to worry about RAM disks.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
By the way, I'm quite curious about your project. I would appreciate it if you could send me an email. Based on the information in my previous post, it shouldn't be too difficult to find me (my company & phone number, or my email address).

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Hi George - what COUNTRY do you live in?
Which of the hundreds in Google with your name are you?

 
Use my first name, my last name, and school bus. I'm in the United States. Well... actually... at the moment I am in Puerto Rico. My wife is trying to start another business which is a hotel/restaurant/bar. Quite a lot different than what we are currently doing.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top