Re: [sqlite] Feature request: Support for aarch64

[Dimiter 'malkia' Stanev]

On 4/23/2013 3:22 PM, James K. Lowden wrote:

On Tue, 23 Apr 2013 09:26:20 -0400
Richard Hipp  wrote:


I really dislike changing autoconf versions since any autoconf upgrade
results in a massive change in the generated "configure" script,
which is annoying to audit before each release, and which results in
exceedingly large and uninstructive diffs between successive versions.


Why keep autoconf output in the source code repository?

I'm not suggesting you should or shouldn't upgrade the version of
autoconf you happen to be using.  I find upgrading it to be a burden,
too, even without the added burden of effects on the repository.  But
having maintained a smaller project for a similar number of years, I've
never been tempted to archive configure scripts.

--jkl



Maybe it's simply to guard from generating different ./configure files 
on each machine depending on what autotools were installed (I have very 
basic knowledge there so I could be wrong).



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Writing in a blob

[Dimiter 'malkia' Stanev]

On 4/23/2013 3:17 PM, James K. Lowden wrote:

On Tue, 23 Apr 2013 10:28:35 -0400
Richard Hipp  wrote:


In summary:  No, a bare SQLite blob does not provide file-system
semantics.  But you can write a wrapper library around SQLite that
does provide file-system semantics for large blobs, and doing so
would have many advantages and be a worth-while project, I think.


A better and simpler answer IMO would be FUSE
(http://fuse.sourceforge.net/) backed by SQLite.  That gives you true
file semantics, not that that's exactly a step forward.  ;-)

--jkl



And on Windows one can use Dokan:
http://dokan-dev.net/en/download/

Or this commercial offering:
Callback file system (I'm not affiliated with them)
http://www.eldos.com/cbfs/

___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] compiling tools for winrt

[Dimiter 'malkia' Stanev]

This looks like general compile problem.

The imported functions below are found in kernel32.dll (kernel32.lib 
import library). But I'm not sure whether under WinRT kernel32.dll is 
still used (it might be).


If you can either add kernel32.lib to your link flags, or with pragma

#ifdef _MSC_VER
#pragma comment(lib, "kernel32.lib")
#endif

On 1/9/2013 3:04 PM, E. Timothy Uy wrote:

Hi, in xcompiling tools for winrt I get the errors below. I suspect this
because I am using the vcvars for cross compiling winrt. Is there a way to
make this work?

MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol
__imp__IsDebuggerPresent@0 referenced in function ___raise_securityfailure
MSVCRT.lib(gs_report.obj) : error LNK2019: unresolved external symbol
_IsProcessorFeaturePresent@4 referenced in function ___report_gsfailure
MSVCRT.lib(crtexe.obj) : error LNK2019: unresolved external symbol
__imp__EncodePointer@4 referenced in function _pre_c_init
MSVCRT.lib(atonexit.obj) : error LNK2001: unresolved external symbol
__imp__EncodePointer@4
MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
__imp__QueryPerformanceCounter@4 referenced in function
___security_init_cookie
MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
__imp__GetCurrentProcessId@0 referenced in function ___security_init_cookie
MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
__imp__GetCurrentThreadId@0 referenced in function ___security_init_cookie
MSVCRT.lib(gs_support.obj) : error LNK2019: unresolved external symbol
__imp__GetSystemTimeAsFileTime@4 referenced in function
___security_init_cookie
MSVCRT.lib(atonexit.obj) : error LNK2019: unresolved external symbol
__imp__DecodePointer@4 referenced in function __onexit
mkkeywordhash.exe : fatal error LNK1120: 8 unresolved externals
NMAKE : fatal error U1077: '"C:\Program Files (x86)\Microsoft Visual Studio
11.0\VC\bin\cl.exe"' : return code '0x2'
Stop.


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Windows (slow) vs. iOS/OSX (fast) Performance

[Dimiter 'malkia' Stanev]

You said that other people tested it, and verified it, so it's unlikely 
that an Antivirus (or some other software - Inventory, or something 
similar) might be problematic.


Another thing you can do is to fire up procmon (SysInternals) and watch 
writes to your db. - they would happen from your process and from the 
System one (so don't filter out only your process).


Windows XP monitors certain file extensions for backup purposes - you 
might have to check on that one too if your file matches one of the 
listed extensions there (about ~1000)

http://msdn.microsoft.com/en-us/library/aa378870(VS.85).aspx

Check this file too - %windir%\system32\restore\Filelist.xml.

As to Alex - I work in gamedev studio, and we use sqlite for some core 
things, and as much I like that we used OSX/Linux or FreeBSD we are 
stuck with Windows - at least Windows 7 for now (which I like), and no 
plans to upgrade to 8.


On 11/30/2012 9:41 AM, David de Regt wrote:

Hey all.  I've been struggling with a basic perf issue running the same code on 
Windows vs. iOS and OSX.

Basic query set:
CREATE TABLE test (col1 int, col2 text);
[loop 500 times]: INSERT INTO TEST (col1,col2) VALUES (4,'test4')

I'm coding this using the default C amalgamation release and using prepare/etc. 
on all platforms in the exact same way (same very simple DB-access class I 
made).  I realize that using a transaction around this would vastly improve 
perf, but given the atomic nature of the app that this test is simulating, it 
won't work to wrap it into transactions, so my goal is to improve the atomic 
performance.  These are all being run on the same Macbook Pro, with an SSD, 
running Windows via boot camp, OSX natively, and iOS via the iOS simulator:

With defaults (pragma sync = on, default journal_mode):
Windows: 2500ms
iOS: 300ms
OSX: 280ms

With pragma sync = off, journal_mode = memory:
Windows: 62ms
iOS: 25ms
OSX: 25ms

Turning off sync doesn't make me feel warm and fuzzy about our lost-power 
scenario, so with sync on, it seems like something must be fishy for it to be 
~8-9x slower than the other platforms.  Is there something ridiculous about the 
windows file system performance that hoses sqlite's open/read/write/close 
transaction cycle?  Is there anything I can do, or just accept it and move on?  
With how that scales up, we may need to move to something like using embedded 
MySQL or LocalDB on Windows to get the same performance as we see with SQLite 
on other platforms, which seems quite ridiculous.

Thanks!
-David


___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Slow commits

[Dimiter 'malkia' Stanev]

Hi Normand,

Just for sanity, check whether Windows is not creating previous versions 
for you.


Right click on the file in Explorer -> Properties -> Previous Versions.

Also check whether Caching is enabled on your HDD:
Control Panel -> Device Manager -> Disk Drives -> (Click on your HDD)

Then go to the "Policies" tab (should be second). There are two settings:

"Enable write caching on disk" and
"Turn off Windows write-cache buffer flushing on device"

The first one should probably be checked, but second one (if checked) 
would be more dangerous, but faster (at least for me).


It depends how secure your data is. Our data can be regenerated, and 
taken back from P4, and at worst I can lose some hours of work 
(programming).


It's also good idea to check with SysInternals ProcMon what exactly is 
going on.


Another good tool, is SysInternals RamMap - with it you can check what 
portions of the file are in the file-cache (meta-data). You can also 
flush the cache with it, and test various scenarios


Cheers,
Dimiter 'malkia' Stanev,
Senior Software Engineer,
Treyarch, Activision.

On 1/13/2012 3:56 PM, Normand Mongeau wrote:



On 2012-01-13 18:10, Roger Binns wrote:

-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1

On 13/01/12 14:35, Normand Mongeau wrote:

It gets worse. On a clean empty database, the same 534 transactions
take 140 seconds. That's a not very impressive rate of 3.8 inserts
per second. The FAQ says that SQLite should be able to do a "few dozen
transactions per second". I'd be happy to see that.

What file extension are you using for the database? There is a long list
of extensions that System Restore monitors, and makes backups of the
files
as they change. This will kill your performance.


I was using .db as an extension, and changed it to something ludicrous,
but it didn't make a difference. Good idea though.

Thanks,

Normand




Extension list and terse details are at:

http://msdn.microsoft.com/en-us/library/Aa378870

Roger
-BEGIN PGP SIGNATURE-
Version: GnuPG v1.4.11 (GNU/Linux)

iEYEARECAAYFAk8Quc4ACgkQmOOfHg372QQAowCgi0DlewfcHs6MIPIHSyjHw6mN
nFIAnjJch3erZfRF+I88yA3CzAkCQWVl
=HoSZ
-END PGP SIGNATURE-
___
sqlite-users mailing list
sqlite-users-czdrofg0bjidnm+yrof...@public.gmane.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users

Re: [sqlite] Using SQLite on Windows 64bit

[Dimiter 'malkia' Stanev]

I haven't used the SQLite .net modules, a coworker of mine did, and he 
ran into the same issue.


It looks like that the bundled Managed .DLL (or was it native .DLL) was 
compiled for 32-bit, and his .NET application was set to "Default Mode".


Once it was forced to be for 32-bit, it worked.

This could be even changed from the command-line, but I forgot the tool 
doing it. I'll dig up, if you need to.


Thanks!

On 10/26/2011 2:17 AM, J Trahair wrote:

Hi.

I want to install a VB.Net application onto a customer's Windows 64bit computer.

I have my own Windows 64bit laptop with Visual Studio 2010 installed. I have a 
VB.Net application which uses SQLite successfully, both in the development 
runtime, and as an 'installed' program in a separate folder on the same laptop.

However, I have installed the same installation setup.exe on a separate Windows 
64bit computer, and it comes up with the error message
'Could not load file or assembly System.Data.SQLite.dll or one of its 
dependencies, the specified module could not be found.' However, the 
System.Data.SQLite.dll IS there (v.1.0.76). What dependencies does it need 
(64bit)?

Thanks in advance.

Jonathan Trahair



___
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users