w.k

Estonia

Age: 44

Jan
27
accepted Why knockout.mapping fails on some data-structures?
Jan
27
comment Why knockout.mapping fails on some data-structures?
Thank you! Your answer is thorough and enough. I may stop hitting the wall with my head now...
Jan
27
asked Why knockout.mapping fails on some data-structures?
Jan
24
comment Configure Dancer from environment variables?
@JackM. database() returns handler, AFAIR, so you could save it into var like $dbh = database( { driver => ... } )
Jan
23
comment Why Dancer app fails under uWSGI + Apache?
Found out, that www-data usesr did not have same @INC, that's why Perl app was not found. So I got uwsgi run under Apache2 too. Thank you!
Jan
23
accepted Why Dancer app fails under uWSGI + Apache?
Jan
22
comment Why Dancer app fails under uWSGI + Apache?
Sorry for delay. This was good hint and after moving to the 0:psgi I have a little progress. In uwsgi log is now --- unable to find perl application --- and another messy line [pid: 5757|app: -1|req: -1/1] 212.7.22.161 () {66 vars in 1511 bytes} [Sat Jan 23 00:07:15 2016] GET /adm/z/ => generated 21 bytes in 0 msecs (HTTP/1.1 500) 2 headers in 83 bytes (0 switches on core 0) Here I see, that resonse is 21 bytes, what is length of "Internal server error". Do you have any hints more, why Perl app is not found under Apache here?
Jan
19
asked Why Dancer app fails under uWSGI + Apache?
Nov
25
awarded Student
Nov
22
accepted Why DELETE with subquery is much slower than with simple list of IDs?
Nov
20
comment How to enhance scans of golden emboss?
@joojaa Maybe you have idea where to look out for help? Tried to find desktop publishing and scanning and graphic design forums, but no luck so far.
Nov
20
asked How to enhance scans of golden emboss?
Nov
20
comment Why DELETE with subquery is much slower than with simple list of IDs?
@Kickstart hmm, dosc says only row_count, not offset, rowcount
Nov
20
comment Why DELETE with subquery is much slower than with simple list of IDs?
@Kickstart yes, but DELETE does not support LIMIT offset
Nov
20
comment Why DELETE with subquery is much slower than with simple list of IDs?
My thoughts were wandering on the same road, but I did not saw the reasoning, why the subquery should run X time? mysql optimizer seems to work for the completely opposite direction here. Still, thank you for pointing out all those details from docs.
Nov
20
comment Why DELETE with subquery is much slower than with simple list of IDs?
@Shadow So I did, if I run those queries separately it takes about 0.05s (0.01+0.04), but as subquery it takes 53s
Nov
20
comment Why DELETE with subquery is much slower than with simple list of IDs?
@AbhikChakraborty this does not affect the deleting speed, in my real case I use much more complicated SELECT with ORDER and LIMIT. Problem stays. Same select from example above takes separately 0.01 s
Nov
20
asked Why DELETE with subquery is much slower than with simple list of IDs?
Nov
10
awarded Caucus
Nov
1
awarded Scholar
1 2 3 4 5