[sqlite] Very poor SQLite performance when using Win8.1 + Intel RAID1

[Jeremy Nicoll - ml sqlite users]

Rob van der Stel  wrote:

>Hello,
>
> Currently I am investigating a SQLite performance problem that started to
> occur when we switched from using Windows XP to Windows 8.1  for our
> applications.

I don't know anything about SQLite, but faced with what you're seeing I
think I'd want to be sure how much of the problem is SQLite...  Have you
done any I/O benchmarks using other tools? 

Have you checked if there's known problems with the SSDs and/or RAID drivers
you're using?


>The following information is obtained to comparing two hardware identical
systems one running Win XP the other running Win 8.1.

Is W8.1 expected to run as well as XP on similar hardware, or does it need
(for example) much more RAM?

If you install a RAM disk on each system and place your SQLite test database
on that, do you see the same speed problems? 


-- 
Jeremy C B Nicoll - my opinions are my own.

Re: [sqlite] Large Database Windows vs Linux

[Jeremy Nicoll - ml sqlite users]

Roger Binns  wrote:

> Here is the list of monitored extensions:
>
>
http://msdn.microsoft.com/en-us/library/windows/desktop/aa378870(v=vs.85).aspx

That's a frighteningly long list - 574 separate extensions...  And they're
not all obscure ones either.  For example it includes

   .DATA
   .SRC- quite likely to be used for 'a source file' of some sort
   .TAG- surely someone will be tagging their own data?

and I could easily see my choosing many of the others for arbitrary data in
certain projects.

-- 
Jeremy C B Nicoll - my opinions are my own.
___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users