How to make RDBMS ?
From: tony <tony_at_email.com>
Date: Fri, 14 Dec 2001 10:15:17 -0800
Message-ID: <3C1A41B5.2070104_at_email.com>
Hi there.
First of all, If my question totally doesn't relate to this newsgroup, I'm so sorry... since I couldn't find newsgroups for my question, I posted here.
Date: Fri, 14 Dec 2001 10:15:17 -0800
Message-ID: <3C1A41B5.2070104_at_email.com>
Hi there.
First of all, If my question totally doesn't relate to this newsgroup, I'm so sorry... since I couldn't find newsgroups for my question, I posted here.
I'm thinking to make RDBMS itself with C or C++ language.
Before starting, I already got problems...
SELECT * FROM table1;
As you guys know, the statement above retrieve all records in the table1.
It's easy to retrieve from memory, but if the table1 has 1,000,000 rows
and 10 columns, what RDBMS should do with that huge table ?
The RDBMS should put all records in the memory ? 1,000,000 rows & 10
columns r fine, but if the table has 1,000,000,000 & 1,000 columns ?
This is totally wasting memory space if the RDBMS put the all records in
to memory.
anybody knows how RDBMS treats those tables(files) ?
Thank you
tony. Received on Fri Dec 14 2001 - 19:15:17 CET