realbasic-nug
[Top] [All Lists]

Re: RealSQLDatabase/SQLite-based files: poor network performance. Is the

To: "REALbasic NUG" <realbasic-nug at lists dot realsoftware dot com>
Subject: Re: RealSQLDatabase/SQLite-based files: poor network performance. Is there a port issue?
From: "Peter K. Stys" <pkstys at gmail dot com>
Date: Mon, 28 Apr 2008 18:39:35 -0600
Authentication-results: mx.google.com; spf=pass (google.com: domain of realbasic-nug-bounces at lists dot realsoftware dot com designates 66.116.103.65 as permitted sender) smtp dot mail=realbasic-nug-bounces at lists dot realsoftware dot com
Delivered-to: listarchive at realsoftware dot com
Delivered-to: realbasic-nug at lists dot realsoftware dot com
References: <77124270804281149i57918c46se45091d1618a06de at mail dot gmail dot com> <c867e59d0804281359nd7fec4dk97feed353c7258e0 at mail dot gmail dot com>
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???!!!

Peter.

-- 
---------------------------------------------
Peter K. Stys, MD
Dept. of Clinical Neurosciences
Hotchkiss Brain Institute
University of Calgary
tel (403) 210-8646
---------------------------------------------
_______________________________________________
Unsubscribe or switch delivery mode:
<http://www.realsoftware.com/support/listmanager/>

Search the archives:
<http://support.realsoftware.com/listarchives/lists.html>


<Prev in Thread] Current Thread [Next in Thread>