Can Gallery Help me manage 900,000+ pictures (and notes for them)

realized

Joined: 2010-01-31
Posts: 7

Posted: Sun, 2010-01-31 22:52

We are a small company and part of our job involves documenting things – this includes taking before and after pictures of things.

For example – if something needs to get fixed – we need to take pictures of what needs to be fixed – then once its resolved – we need to take more pictures.

We need to have notes for pictures and for the groups – so we can search through them. – and identify groups by date/name/notes

The database would be LOCAL – not on the internet. And only for employees on our private LAN.

Is this something Gallery can do? Has anybody used it with this many pictures? What kind of a computer is recommended to handle a database this large? (cpu/ram?) with gallery?

nivekiam

Joined: 2002-12-10
Posts: 16504

Posted: Mon, 2010-02-01 03:55

Gallery can handle it. Question is can your hardware, which is next to impossible for us to answer because we don't know anything about your setup, expected load, etc.? Best bet is to install Gallery, load up a few dozen images and albums with comments and perform some load testing.

I believe this post here links to nearly everything I've ran across about performance and G2.
http://gallery.menalto.com/node/82413#comment-288705
http://gallery.menalto.com/node/88669

And a few others:
http://gallery.menalto.com/node/34490
http://gallery.menalto.com/node/90261
http://gallery.menalto.com/node/92080
http://gallery.menalto.com/node/89424

There's probably some more information in the forums if you search.

You should also take a look at G3. It's performance is going to be better than G2 and you won't have the overhead of extra cache files for G2. But it may really depend on how you need/want to setup permissions as well.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

realized

Joined: 2010-01-31
Posts: 7

Posted: Tue, 2010-02-02 19:34

Thank you, i will be testing G3

nivekiam

Joined: 2002-12-10
Posts: 16504

Posted: Tue, 2010-02-02 19:39

It really depends on what you're planning on doing with it. G2, right now, has more plugins and themes available for it and G3 is still in development and changes are being made often.

Investigate both options and see which fits best for you.
____________________________________________
Like Gallery? Like the support? Donate now!!! See G2 live here

realized Joined: 2010-01-31 Posts: 7	Posted: Sun, 2010-01-31 22:52
	We are a small company and part of our job involves documenting things – this includes taking before and after pictures of things. For example – if something needs to get fixed – we need to take pictures of what needs to be fixed – then once its resolved – we need to take more pictures. We need to have notes for pictures and for the groups – so we can search through them. – and identify groups by date/name/notes The database would be LOCAL – not on the internet. And only for employees on our private LAN. Is this something Gallery can do? Has anybody used it with this many pictures? What kind of a computer is recommended to handle a database this large? (cpu/ram?) with gallery?
	XUser login Username: * Password: * Create new account Request new password
nivekiam Joined: 2002-12-10 Posts: 16504	Posted: Mon, 2010-02-01 03:55
	Gallery can handle it. Question is can your hardware, which is next to impossible for us to answer because we don't know anything about your setup, expected load, etc.? Best bet is to install Gallery, load up a few dozen images and albums with comments and perform some load testing. I believe this post here links to nearly everything I've ran across about performance and G2. http://gallery.menalto.com/node/82413#comment-288705 http://gallery.menalto.com/node/88669 And a few others: http://gallery.menalto.com/node/34490 http://gallery.menalto.com/node/90261 http://gallery.menalto.com/node/92080 http://gallery.menalto.com/node/89424 There's probably some more information in the forums if you search. You should also take a look at G3. It's performance is going to be better than G2 and you won't have the overhead of extra cache files for G2. But it may really depend on how you need/want to setup permissions as well. ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

realized Joined: 2010-01-31 Posts: 7	Posted: Tue, 2010-02-02 19:34
	Thank you, i will be testing G3

nivekiam Joined: 2002-12-10 Posts: 16504	Posted: Tue, 2010-02-02 19:39
	It really depends on what you're planning on doing with it. G2, right now, has more plugins and themes available for it and G3 is still in development and changes are being made often. Investigate both options and see which fits best for you. ____________________________________________ Like Gallery? Like the support? Donate now!!! See G2 live here

Can Gallery Help me manage 900,000+ pictures (and notes for them)

XUser login