LinuxQuestions.org
View the Most Wanted LQ Wiki articles.
Go Back   LinuxQuestions.org > Forums > Non-*NIX Forums > Programming
User Name
Password
Programming This forum is for all programming questions.
The question does not have to be directly related to Linux and any language is fair game.

Notices

Reply
 
Search this Thread
Old 07-05-2006, 02:20 AM   #1
koodoo
Member
 
Registered: Aug 2004
Location: a small village faraway in the mountains
Distribution: Fedora Core 1, Slackware 10.0 | 2.4.26 | custom 2.6.14.2, Slackware 10.2 | 11.0, Slackware64-13
Posts: 345

Rep: Reputation: 32
In Memory SQL type tables


Hi,

I am looking for a way to implement In Memory Tables. I have a some data that I need to access quite fast, but I also need the functionality that an SQL table offers me. Eg Querries for searching, etc. So is there any way I can load an SQL type table into memory and then Querry that table?.

I could implement, say some dyanamic data stuctures and then write some operations for them, but that seems to be a lot of work. Moreover I would have to make a lot of changes in my existing code. What I am looking for here is that, in the normal case when my prog executes a Querry from a table, that table is on the disk and so the Querry takes time. I was tinking if there was some way to load that same same table into memory and then Querry it from there.

Thanks in anticipation.
 
Old 07-05-2006, 04:02 AM   #2
r0b0
Member
 
Registered: Aug 2004
Location: Europe
Posts: 602

Rep: Reputation: 49
All operating systems cache files to memory. So I think you can just place your database in a file and the operationg system will take care of the performance.
You won't really gain anything trying to re-invent things that have already been used for tens of years now.
 
Old 08-05-2006, 03:55 AM   #3
koodoo
Member
 
Registered: Aug 2004
Location: a small village faraway in the mountains
Distribution: Fedora Core 1, Slackware 10.0 | 2.4.26 | custom 2.6.14.2, Slackware 10.2 | 11.0, Slackware64-13
Posts: 345

Original Poster
Rep: Reputation: 32
Hi,
Sorry for such a late reply. Actually I was away for sometime so couldn't reply.

I think you didn't quite get what I was trying to accomplish. I had posted a similar question on cprogramming.com and got a very good reply.

Here's a link to the thread.

Here are some more links for someone who might be facing the same problem:
1) This is the SQLITE home page.

2) http://www.sqlite.org/cvstrac/wiki
Go to "Information On SQLite Internals"--->"InMemoryDatabase: Notes on how to use SQLite for in-memory tables."

Thanks anyways.
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
tool to detect number of memory slots, memory module type, speed, and size stefanwolf Linux - Hardware 8 04-22-2013 09:48 AM
SQL: tables and queries in school project cold Programming 1 10-29-2005 07:58 PM
How to compare records in two tables in seperate My Sql database using shell script sumitarun Programming 5 04-14-2005 09:45 AM
SQL: making queries from multiple tables ganninu Programming 1 01-08-2004 11:17 AM
SQL query, comparing tables ngomong Programming 3 07-07-2002 07:44 PM


All times are GMT -5. The time now is 09:06 AM.

Main Menu
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
identi.ca: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration