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]> wrote:
>
> I didn't look at it that closely, as the FilesystemStore was suitable for
> our environment.
>
>
>
> *From:* [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] *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] *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] *On Behalf Of *Astralis Lux
> *Sent:* Friday, November 23, 2007 3:23 AM
> *To:* 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
> 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
