Thank you for the tip!
The performance went up with 20% with one computer and 50% with an
other...

This is really good news for us.

Simon

--- In ib-support@y..., "Ali Gokcen" <alig@e...> wrote:
> There is a virtual-RAMDISK drive in windows 9x systems, called
> RAMDRIVE.sys
> you should write it in config.sys:
> DEVICE = C:\WINDOWS\RAMDRIVE.sys [ capacity] [ cluster size]
( use
> system help for details)
> ( choice cluster size same as PAGE_SIZE of your db)
>
> in win2k there is 3th party drivers,
> i found one of them for you from web.
> look at
> http://www.eecsys.com
>
> Give a small size to pagefile.sys ( windows.swp) to force windows
to use
> phsical mem (RAM) if you have enough.
>
> after all, if you still have performance problem, you can try my
old advice.
> you can use a fixed record length file for insert, you can query it
from IB
> as a table, can insert. but update/modify/index.
> i think you can insert more than 50,000 recs/sec.
> Your query performance will not reduce because IB nearly reads all
rows
> from a table to create your CURSOR.
> you can delete this file after move it to an archive table in
idle time.
> ( look langref.pdf to create table as external )
>
> ----- Original Message -----
> From: Simon Rydberg
> To: ib-support@y...
> Sent: Thursday, February 01, 2001 2:59 PM
> Subject: Re: [ib-support] Interbase in the memory (RAM)
>
>
> How do you create a RAM-disk???
> Is it hard? Is their any info about it on the web?
>
> Simon
>
>
> One thing you would might want to do, is to create a RAM disk and
then let
> your TMP swap space point to that. That would help on performance.
>
> Steffen