XnView Software

Steps: 0. Close the program 1. Copy the catalog in a new file. ("XnView - copy.db" on my PC) 2. Open the original file in you SQLite tool - it has the page size of 1024. 3. Run the following: "Select * from Datas" limit 2000; (it brings 2000 records from thumbnails table - the most heavy table which...

I've made some tests 19000 pictures (PNG+JPEG) Thumbnails creation without DB => 14min Thumbnails creation with DB => 15min Thumbnails loading => 9sec Modifying cache size or synchronous has no effect here Sure. Cache size has no effect on thumbnail creation. It has on searching (READING data from ...

I've seen that You must call open on your sqlite file to create a connection on each thread, don't share connections between threads. Currently i share my db connection, i can have a thread that build thumbnails and one (or more) that read... The above statement is valid IF the SQLite is NOT compil...

If you have valuable Categories / Assignments - generally items tied to On-Database Photo Management DO NOT do the following! It is a bug which wipes your entire catalog. Steps to reproduce: 1. Go to DB Manager (Tools > Settings > Cache DB...) 2. Click "Clean Thumbnails" 3. Wait (no warning appears ...

Yes, I agree too and understand. So that it would be like how Windows does it (the option it gives): http://i.imgur.com/TyojdY8.png Sure! Of course! And more: I can live without the counter of conflicts (it needs a more complex logic - prefetching the file list in the target folder which can have s...

http://www.sqlite.org/pragma.html#pragma_synchronous No risk if 2 threads work on same DB? Nope. Ok, there are risks but not because of SQLite's engine (assuming that you use the default compilation settings) but because of your code (you know, race conditions, deadlock between threads - the classi...

Yet another thing which hinders the On-Disk File Management (ie. the File Manager features), besides of big ones like... ...the lack of drag & drop http://newsgroup.xnview.com/viewtopic.php?f=60&t=28147 ...and the lack of File Management commands in File Folders tree http://newsgroup.xnview.com/view...

1. Synchronous mode is Full. This is slow. You can do ' pragma synchronous=1 ' (normal) in order to obtain substantial performance gains with very little risk. Just checked - it works faster. What is the risk? http://www.sqlite.org/pragma.html#pragma_synchronous 2. Your page cache is too low (2000 ...

... 1. 'Datas' table has the thumbnails in it, right? yes 1a. Then what's the purpose of 'Created' and 'Size' fields? Created date, and size of the size, to compare at loading if file has changed I think that you don't need the 'Created' field in the 'Datas' table. Why do you need the 'created' tim...

Well, it is very good to 'ask'. But not XnViewMP. In Batch Convert, that is. In Batch Convert there is a setting called 'When output file already exists' which defaults to 'Ask'. When one has to convert many files and, let's say, 100 of them already exist on destination folder (because of various re...

...Also, IDImager implements the notion of the temporary album which is emptied at the end of session (as you see, it is called Image Basket - someting similar can be configured in XnViewMP with Tags) ... And it's sorted by default by the "EXIF date taken" (or if not : XMP, or IPTC, or creation dat...

Something like ImageID, Tag Yes, sort of. Database layer: I will speak in SQL (not tested): -- first we'll create the Albums Create Table Albums (AlbumID Integer Primary Key Autoincrement, AlbumName Text Not Null Unique); Insert into Albums values(null, 'Tag'); -- the 'null' here will became 1 due ...

In the DB we have the table 'Images' which has for each image the field 'Tag' of type INTEGER. However, the architecture isn't very good. Since 'Tag' is a sparse field (ie. very few tagged files in a sea of untagged ones) the best solution would be to move the 'Tag' field in another table to hold on...

Hello Pierre, at the moment I do not know how to send you such a file, because all my *.orf files have a size about 10MB. Can I send you such a file via e-mail? But I think this is not necessary, after I have explained my feature request again: I have an image (*.orf or another RAW-format or maybe ...

Well, I find this image viewer the best for Windows, but I have a little problem. After x goes (x+1)_y, but it's wrong. Can you change algorithm to show (x+1) after x or add an option for this? NIce message :D Good encryption. :D ...but can you explain what / who is "x" and "y" and what operator is...