Announcement

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

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

jortex696
Member
2010-05-13
62

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

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.

Offline

 

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

flop25
Piwigo Team
2006-07-06
7037

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

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


To get a better help : Politeness like Hello-A link-Your past actions precisely described
Check my extensions : more than 30 available
who I am and what I do : http://fr.gravatar.com/flop25
My gallery : an illustration of how to integrate Piwigo in your website

Offline

 

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

jortex696
Member
2010-05-13
62

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

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'?

Offline

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

Board footer

Powered by FluxBB

github twitter newsletter Donate Piwigo.org © 2002-2022 · Contact