| Subject | Re: [ib-support] Re: Interbase in the memory (RAM) |
|---|---|
| Author | Olivier Mascia |
| Post date | 2001-01-31T14:48:18Z |
Yes, I understand your idea Simon.
(Didn't wanted to be rude with you, but I really thought it was a joke :-)
Your '15,000 rows a second' problem should be clearly defined and exposed
in detail before anybody can try to give you valid recommendations.
We know you talked about 15,000 inserts a second.
We do not know the exact structure of that row.
We do not know if you have to sustain a rate of 15,000 rows a second ?
For how much time ?
Or are these bursts every other minute ?
Where does that data come from ?
Produced by the program itself ? Read from some peripheral ?
Or from the LAN ? Will the source of the data itself even sustain the
15,000 rows a second ?
Is this idea of inserting 15,000 rows a theorical exercise for you ? Or do
you even have a real case ?
I am willing to help within my knowledge limits, but I'd sincerely would
like the problem to be real a "real life" case and not just a hypothetical
query. At least I first would like the problem to be clearly and completely
defined.
Else we will loose much precious time, you, me and others.
The very basic recommendation would of course be to get decent cpu power
(single processor), very fast ram, very fast SCSI I/O controller, excellent
disks, maybe in a striping configuration or RAID 0+1 configuration
depending on the added I/O speed wanted and/or protection.
Olivier.
-- On 31/01/2001 12:56 +0000 simpor81@... wrote :
(Didn't wanted to be rude with you, but I really thought it was a joke :-)
Your '15,000 rows a second' problem should be clearly defined and exposed
in detail before anybody can try to give you valid recommendations.
We know you talked about 15,000 inserts a second.
We do not know the exact structure of that row.
We do not know if you have to sustain a rate of 15,000 rows a second ?
For how much time ?
Or are these bursts every other minute ?
Where does that data come from ?
Produced by the program itself ? Read from some peripheral ?
Or from the LAN ? Will the source of the data itself even sustain the
15,000 rows a second ?
Is this idea of inserting 15,000 rows a theorical exercise for you ? Or do
you even have a real case ?
I am willing to help within my knowledge limits, but I'd sincerely would
like the problem to be real a "real life" case and not just a hypothetical
query. At least I first would like the problem to be clearly and completely
defined.
Else we will loose much precious time, you, me and others.
The very basic recommendation would of course be to get decent cpu power
(single processor), very fast ram, very fast SCSI I/O controller, excellent
disks, maybe in a striping configuration or RAID 0+1 configuration
depending on the added I/O speed wanted and/or protection.
Olivier.
-- On 31/01/2001 12:56 +0000 simpor81@... wrote :
> The idea that I had whas that you could do all the transactons and
> som on in the memory and then, let's say every five minute to write
> the data to the harddrive.
>
> Maybe it was a crazy idea!
>
> --- In ib-support@y..., Olivier Mascia <om@t...> wrote:
>> Is this a joke ?
>> What's the database need, if you do not want to _store_ the data ?
>>
>> Olivier.
>>
>> -- On 31/01/2001 11:38 +0000 simpor81@h... wrote :
>>
>> > Is it possible to make Interbase run in the memory of a machine.
> From
>> > my knowledge is the writing to the harddrive the thing that takes
> the
>> > most time. So if you were able to put the hole database in the RAM
>> > then would it be really quick, wouldn't it.
>> >
>> > Just a little thought that I have had.
>> >
>> > Simon