Search found 1575 matches

by m.Th.
Mon Jun 24, 2013 9:34 am
Forum: MP - Suggestions
Topic: From 5.03 seconds to 306 miliseconds (!)
Replies: 4
Views: 424

From 5.03 seconds to 306 miliseconds (!)

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...
by m.Th.
Mon Jun 24, 2013 9:18 am
Forum: MP - Suggestions
Topic: Database performance
Replies: 29
Views: 2407

Re: Database Performance

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 ...
by m.Th.
Mon Jun 24, 2013 9:14 am
Forum: MP - Suggestions
Topic: Database performance
Replies: 29
Views: 2407

Re: Database Performance

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...
by m.Th.
Mon Jun 24, 2013 9:09 am
Forum: MP - Suggestions
Topic: How to blow up your entire Catalog with one click
Replies: 5
Views: 512

How to blow up your entire Catalog with one click

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 ...
by m.Th.
Sat Jun 22, 2013 4:29 pm
Forum: MP - Suggestions
Topic: Do NOT "ask" XnViewMP
Replies: 2
Views: 393

Re: Do NOT "ask" XnViewMP

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...
by m.Th.
Sat Jun 22, 2013 4:26 pm
Forum: MP - Suggestions
Topic: Database performance
Replies: 29
Views: 2407

Re: Database Performance

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...
by m.Th.
Sat Jun 22, 2013 8:52 am
Forum: MP - Suggestions
Topic: On-Disk Management: Yet another (easy) topic
Replies: 1
Views: 451

On-Disk Management: Yet another (easy) topic

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...
by m.Th.
Sat Jun 22, 2013 6:43 am
Forum: MP - Suggestions
Topic: Database performance
Replies: 29
Views: 2407

Re: Database Performance

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 ...
by m.Th.
Fri Jun 21, 2013 10:15 am
Forum: MP - Suggestions
Topic: Database performance
Replies: 29
Views: 2407

Re: Database Performance

... 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...
by m.Th.
Fri Jun 21, 2013 9:26 am
Forum: MP - Suggestions
Topic: Do NOT "ask" XnViewMP
Replies: 2
Views: 393

Do NOT "ask" XnViewMP

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...
by m.Th.
Fri Jun 21, 2013 9:19 am
Forum: MP - Suggestions
Topic: Rethinking Tags
Replies: 6
Views: 706

Re: Rethinking Tags

...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...
by m.Th.
Fri Jun 21, 2013 8:32 am
Forum: MP - Suggestions
Topic: Rethinking Tags
Replies: 6
Views: 706

Re: Rethinking Tags

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 ...
by m.Th.
Fri Jun 21, 2013 7:40 am
Forum: MP - Suggestions
Topic: Rethinking Tags
Replies: 6
Views: 706

Rethinking Tags

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...
by m.Th.
Fri Jun 21, 2013 6:36 am
Forum: MP - Suggestions
Topic: Rotating images only in GUI
Replies: 5
Views: 1033

Re: Rotating images only in GUI

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 ...
by m.Th.
Fri Jun 21, 2013 6:26 am
Forum: MP - Suggestions
Topic: Request: Changes in categorization
Replies: 3
Views: 314

Re: Request: Changes in categorization

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...