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
