Database vs. RAM
-
hi, what is better (faster), if i read some information from the database each time i need it? or if i read all the information i need and stock them into an array in the ram and close the connection to the Db. and so i access only that array if it necessary. thx
-
hi, what is better (faster), if i read some information from the database each time i need it? or if i read all the information i need and stock them into an array in the ram and close the connection to the Db. and so i access only that array if it necessary. thx
Well if the database is located on disk then disk access is alot slower than RAM access, but if th database is located in memory then it's related to the type of database and such details...etc. Hope this helps:)
To follow the path, Walk with the MASTER, See through the MASTER, Be the MASTER!
-
Well if the database is located on disk then disk access is alot slower than RAM access, but if th database is located in memory then it's related to the type of database and such details...etc. Hope this helps:)
To follow the path, Walk with the MASTER, See through the MASTER, Be the MASTER!
thank you for the answer, the database is located on disk, and its a ms access database
-
thank you for the answer, the database is located on disk, and its a ms access database
Then it becomes a matter of which is faster: milliseconds or nanoseconds?
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
-
Then it becomes a matter of which is faster: milliseconds or nanoseconds?
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne
You are right but when it comes to tons of information and data, the difference will be seconds to even minutes!
To follow the path, Walk with the MASTER, See through the MASTER, Be the MASTER!
-
You are right but when it comes to tons of information and data, the difference will be seconds to even minutes!
To follow the path, Walk with the MASTER, See through the MASTER, Be the MASTER!
Mohamad K Ayash wrote:
...the difference will be seconds to even minutes!
Doubtful.
"A good athlete is the result of a good and worthy opponent." - David Crow
"To have a respect for ourselves guides our morals; to have deference for others governs our manners." - Laurence Sterne