|Home » Technical Support » DBISAM Technical Support » Support Forums » DBISAM General Discussion » View Thread|
|Messages 1 to 10 of 23 total|
|Speeding things up|
|Mon, Sep 17 2007 7:12 AM||Permanent Link|
"Overall, based on elapsed time, the SSD array performed the queries 276
times faster than the ATA array."
It makes me wonder if this is a way to speed things up. A 32Gb SSD is
available from stock in the UK for 300 GBP (approx US$600). Since our app
copies all the databases to a temporary location, this may be worth
|Mon, Sep 17 2007 8:51 AM||Permanent Link|
Someone elsewhere has pointed out that the article is from 2005, but it is
probably still relevant. I'm going to look into using a RamDisk for a
test, which would be cheaper.
|Mon, Sep 17 2007 11:07 AM||Permanent Link|
"Frans van Daalen"
"Matthew Jones" <email@example.com> wrote in message
> Someone elsewhere has pointed out that the article is from 2005, but it is
> probably still relevant. I'm going to look into using a RamDisk for a
> test, which would be cheaper.
> /Matthew Jones/
MTRON SSD 32GB: Wile E. Coyote or Road Runner?
|Mon, Sep 17 2007 3:18 PM||Permanent Link|
Tim Young [Elevate Software]
Elevate Software, Inc.
<< MTRON SSD 32GB: Wile E. Coyote or Road Runner? >>
Wow, very impressive. Especially since 32GB is well within the range of
most smaller databases.
|Tue, Sep 18 2007 4:38 AM||Permanent Link|
"Frans van Daalen"
"Tim Young [Elevate Software]" <firstname.lastname@example.org> wrote in message
> << MTRON SSD 32GB: Wile E. Coyote or Road Runner? >>
> Wow, very impressive. Especially since 32GB is well within the range of
> most smaller databases.
Yes, it's on my list
Shame that they did not have a db test.
HP (Alienware) created a laptop with dual-ssd 64gb in raid0 !
|Tue, Sep 18 2007 8:45 AM||Permanent Link|
"Frans van Daalen" <Account@is.invalid> skrev i en meddelelse
>> << MTRON SSD 32GB: Wile E. Coyote or Road Runner? >>
>> Wow, very impressive. Especially since 32GB is well within the range
>> of most smaller databases.
> Yes, it's on my list
> Shame that they did not have a db test.
I'm going to order one of these(maybe the 2,5" depending on
The combination of 0,1ms seektime and read/write speeds of
80MByte/100MByte per second seems quite nice
....the main purpose is to do some DB testing(BTrieve, MSSQL and DBISAM
I will report back when the disk arrive...
|Tue, Sep 18 2007 11:22 AM||Permanent Link|
> I will report back when the disk arrive...
|Wed, Sep 26 2007 6:08 AM||Permanent Link|
Okay, sometimes good things happen when your mind can have time to think.
I haven't managed to get around to buying an SSD drive to experiment with
yet. But I had on my todo list getting a RAM drive to experiment with
first. Then in a discussion about this, someone said "pity we can't hold
the whole database in memory", and I went "D'oh!".
So, the situation is that I have a set of tables and queries that
currently point to local tables. There may be more than one set of these
in threads, each with their own session. What would I need to do to make
these use a single memory table for the big write, and then at the end
have the tables "dumped" to disk? I'm hoping that the index writing in
particular would be much faster in memory.
Can I just set a "use memory" flag somewhere, or is there more to it.
Please point me at anything relevant. Many thanks.
|Wed, Sep 26 2007 8:58 AM||Permanent Link|
All you need to do to use a memory table (in DBISAM .. its a bit more complex in ElevateDB) is create a table in memory, set the TDBISAMTable's database to memory and go.
Best way to create the table is to use a TDBISAMQuery with its database set to memory.
I hope that's what you were asking. It would be good if you gave a few more details of what it is you're doing - this thread moved from SSD to how to "use memory" flag and I'm a bit lost
|Wed, Sep 26 2007 12:43 PM||Permanent Link|
That does answer what I'm asking. I raised SSD because it looked like it
may give better database performance than disk. Then I realised that
"memory" would be faster still. No point spending on fancy SSD if the
basic thing does it better.
|Page 1 of 3||Next Page »|
|Jump to Page: 1 2 3|