On Apr 28, 2008, at 5:39 PM, Peter K. Stys wrote:
> On Mon, Apr 28, 2008 at 2:59 PM, Trausti Thor Johannsson <tj at quarksbar dot
> net
> >
> wrote:
>
>> RealSQL (SQLite) is not meant to be used on a network drive, there
>> are
>> issues with that.It is totally a local database.
>>
>> Like with so many other things, you can be lucky and all works for
>> you,
>> but
>> I guess the sqlite engine is working quite a lot in memory and
>> might cause
>> quite a lot of traffik on your network.
>>
>
>
> I read the cautions (and even tested myself) about multiuser access
> to a
> single large SQLite DB using the non-REALSQLserver version. And
> indeed
> multiuser access to a single SQLite networked file is unreliable.
> But what
> I'm talking about is a single user access to a single file over the
> network
> volume mounted via afp, so I fully expected this to perform as well
> as any
> Finder copy, or close to it.
>
> Are you telling me that just because it's an SQLite file I might
> expect a
> 10-fold performance hit???!!!
File copies are significantly faster because the file is read and
written sequentially.
When you save a file across a network, the reads and writes are not
sequential, so it takes longer. 10 times longer wouldn't be that much
out of line.
--
Glenn L. Austin <><
Computer Wizard and Race Car Driver
<glenn at austin-home dot com>
<http://www.austin-home.com/glenn/>
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>
Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>
|