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: "Trausti Thor Johannsson" <tj at quarksbar dot net>
Date: Mon, 28 Apr 2008 22:59:46 +0200
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>
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.

Trausti

On Mon, Apr 28, 2008 at 8:49 PM, Peter K. Stys <pkstys at gmail dot com> wrote:

> Hi Folks:
> I migrated my image file format to a RealSQLDatabase-based format and it's
> really excellent, makes life a whole lot easier.  However I noticed that
> reading/writing my files from a network volume is very slow, whereas
> Finder
> copies (which I gather run via AFP on port 548) are lightning fast on our
> Gbit LAN.
>
> Is there a port issue I should be looking into (to be clear, this is not
> REALSQLserver, just plain vanilla RealSQLDatabase access of files that are
> on a regularly mounted network volume)?
>
> I think not as these read/writes should also just be running via AFP on
> port
> 548, but you never know.
>
> Thanks,
> 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>
>
_______________________________________________
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>