Welcome Guest! To enable all features please Login or Register.

Notification

Icon
Error
Synchronize speed very slow (0.1 object/sec)
Options
Previous Topic Next Topic
Dickster
#1 Posted : Friday, 17 June 2011 2:06:08 PM(UTC)
Rank: Newbie

Joined: 6/12/2010(UTC)
Posts: 2
Just installed the 2.5 version of the gallery.

Gallery consists of approx. 10k of photo's (2,5-3,5 MB each). When synchronising i get a speed of 0.1 object a second.

I remeber faster synchronising under previous versions of the gallery.

I ran the gallery on a slow machine (atom 1,6 Ghz and 2 GB of RAM).

Is this normal or is there a possible setting to speed up the synchronisation proces.
Back to top
Roger Martin
#2 Posted : Friday, 17 June 2011 9:30:02 PM(UTC)
Roger Martin

Rank: Administration

Joined: 3/08/2007(UTC)
Posts: 3,300
Location: Fort Atkinson, WI
I have found SQL CE to be somewhat slower than both SQLite and SQL Server. I just ran some tests where I sync'd 137 images that averaged 2.6 MB each.

GSP 2.5.0, SQL CE: .4 files/second
GSP 2.4.8, SQLite: .6 files/second
GSP 2.4.8, SQL Server: .5 files/second
GSP 2.5.0, SQL Server: .6 files/second

Notice that SQLite and the 2.5.0 version of SQL Server are about 50% faster than SQL CE.

Remember that these performance numbers would vary widely depending on they type of media objects you are processing. During a sync, most of the work is building thumbnail and optimized images - the database communication is a relatively small part of that. The bigger your images, the more this is true (for example, syncing a bunch of 50 MB images would take over 99% of the processor time just to process the image files).

For the ultimate in performance, you may want to use SQL Server, including the free SQL Server Express. I haven't explicitly tested Express, but I would expect numbers similar to SQL Server.
Roger Martin
Creator and Lead Developer of Gallery Server Pro
Back to top
WWW
Dickster
#3 Posted : Saturday, 18 June 2011 4:19:23 AM(UTC)
Rank: Newbie

Joined: 6/12/2010(UTC)
Posts: 2
Thanks for the answer. I returned to the 2.4 version and the speed's increased significantly.

I have speeds of 0.3-0.9 depending on files.

I will stay with the 2.4.8 version for now.
Back to top
Hyde
#4 Posted : Saturday, 18 June 2011 6:42:42 AM(UTC)
Rank: Advanced Member

Joined: 7/11/2008(UTC)
Posts: 65
Location: UK
Same slow response here. Also received numerous HTTP 12002 sync errors. Ironically more of these running a browser via RDP on the server where the app and files exist than running a browser wirelessly from my laptop.
Back to top
Rss Feed  Atom Feed
Users browsing this topic
Guest
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

Powered by YAF 1.9.5.5 | YAF © 2003-2011, Yet Another Forum.NET