Hi John
We use the file system store here, but we've got an absolute stack of sql
servers around the business, and we develop in sql server (and I am very used
to tracking down performance issues!).
I was considering investigating to see why sql store is slower (and it sounds
like here that it is considerably slower), but since we don't actually have a
requirement to move to it then it's one of those things that is on the todo
list...
Best wishes
James
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of John Davidson
Sent: 27 November 2007 23:03
To: FlexWiki Users Mailing List
Subject: Re: [Flexwiki-users] Which is truly faster? Flat file or MSSQLServer
I also ran it for a while, but needed to turn on full text indexing to get it
work acceptably - that was in 1.8
Once we release 2.0 I will try it again.
The answer to the question though was which is faster and it was clearly
FileSystem faster than SQL.
John Davidson
On 11/27/07, Jimmy Sieben <[EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]>> wrote:
I didn't look at it that closely, as the FilesystemStore was suitable for our
environment.
From: [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> [mailto:[EMAIL
PROTECTED]<mailto:[EMAIL PROTECTED]>] On Behalf Of James Berry
Sent: Tuesday, November 27, 2007 7:06 AM
To: 'FlexWiki Users Mailing List'
Subject: Re: [Flexwiki-users] Which is truly faster? Flat file or MSSQLServer
Hi Jimmy
Did you do any sql tracing to see if it were just the increased latency of sql
access, or whether it was due to poor (or no) index selection?
Best wishes
James
From: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> [mailto:[EMAIL
PROTECTED]<mailto:[EMAIL PROTECTED]>] On Behalf Of Jimmy Sieben
Sent: 26 November 2007 18:21
To: FlexWiki Users Mailing List
Subject: Re: [Flexwiki-users] Which is truly faster? Flat file or MSSQLServer
I tested both for our intranet setup a couple years ago in the 1.8 days (about
the time of build 1677). I found the MSSQL unusable compared to the filesystem.
I don't remember the details, but the perf was really bad in my testing.
From: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> [mailto:[EMAIL
PROTECTED]<mailto:[EMAIL PROTECTED]>] On Behalf Of Craig Andera
Sent: Friday, November 23, 2007 6:28 AM
To: 'FlexWiki Users Mailing List'
Subject: Re: [Flexwiki-users] Which is truly faster? Flat file or MSSQLServer
I don't think anyone has ever tested. I also suspect it depends on hardware,
the size of your wiki, the load, and whether the SQL Server is local or remote.
But I'm not even sure the question is meaningful. It's entirely possible that
one is faster for some operations and the other is faster for others. A better
question to ask is, "Which one will handle the load I need at the response time
I require?"
Generally, I'd recommend that people stick with the filesystem implementation
unless they have some reason to use the SQL one.
From: [EMAIL PROTECTED]<mailto:[EMAIL PROTECTED]> [mailto:[EMAIL
PROTECTED]<mailto:[EMAIL PROTECTED]>] On Behalf Of Astralis Lux
Sent: Friday, November 23, 2007 3:23 AM
To:
flexwiki-users@lists.sourceforge.net<mailto:flexwiki-users@lists.sourceforge.net>
Subject: [Flexwiki-users] Which is truly faster? Flat file or MSSQL Server
This might be a softball question, but when using FlexWiki, which version is
better for performance: flat files or MSSQL Server?
________________________________
Get the power of Windows + Web with the new Windows Live. Power
up!<http://www.windowslive.com?ocid=TXT_TAGLM_Wave2_powerofwindows_112007>
-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Flexwiki-users mailing list
Flexwiki-users@lists.sourceforge.net<mailto:Flexwiki-users@lists.sourceforge.net>
https://lists.sourceforge.net/lists/listinfo/flexwiki-users
-------------------------------------------------------------------------
SF.Net email is sponsored by: The Future of Linux Business White Paper
from Novell. From the desktop to the data center, Linux is going
mainstream. Let it simplify your IT future.
http://altfarm.mediaplex.com/ad/ck/8857-50307-18918-4
_______________________________________________
Flexwiki-users mailing list
Flexwiki-users@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/flexwiki-users
