Piwigo.org

jortex696 · 2011-07-17 04:35:05

LOCK TABLE ---> change to --> SELECT * FROM TABLE WITH (nolock)

Good night ...

As you know, piwigo block tables while doing updated pictures, or a quick synchronization.

In my case when trying to synchronize 1,700,000 images and 60,000 categories about this become really slow.

As a solution I've been reading that mysql can do the following ...

I put it to the attention of developers piwigo.

Please take the time to watch this website.
http://www.itecsoftware.com/with-nolock … -for-mysql

I appreciate any answers or suggestions to my application.
I do this in order to improve performance in piwigo.

flop25 · 2011-07-17 15:57:36

Hello
thx again for helping us ! ^^
please take into account we're not mysql exclusive, but yes I'm pretty sure that kind of request exists in postgresql etc

jortex696 · 2011-07-17 16:33:42

hello

I understand that I have a large database and continues growing rapidly.

Think it's possible such improvements in the consultations to try to do something with the lock tables'?

Piwigo.org

Announcement

#1 2011-07-17 04:35:05

LOCK TABLE ---> change to --> SELECT * FROM TABLE WITH (nolock)

#2 2011-07-17 15:57:36

Re: LOCK TABLE ---> change to --> SELECT * FROM TABLE WITH (nolock)

#3 2011-07-17 16:33:42

Re: LOCK TABLE ---> change to --> SELECT * FROM TABLE WITH (nolock)

Board footer