|
|
 | | Re: Gallery speed
|
| Kevin Loch wrote in message ... (...) 24 (...) Might be quicker to do it in 2 stages, first the line above without the DISTINCT into a cursor, then do a SELECT DISTINCT from that. SELECT file_parent FROM files ORDER BY file_modify_time DESC into (...) (23 years ago, 6-Jul-01, to lugnet.off-topic.geek)
| | | | | Re: Gallery speed
|
| (...) One speed-up would be to store the modify date/time of each folder (updated when a file is added / updated / deleted) and then query directly against the folders. It also depends on your back-end query optimiser - even if you're only selecting (...) (23 years ago, 5-Jul-01, to lugnet.off-topic.geek)
| | | | | Gallery speed
|
| I think I've fixed the painfully slow performance of the "recent" page. There were some indexes missing in the database that really should have been there. It loads reasonably fast now (~.8 seconds unless the machine is really busy). If there are (...) (23 years ago, 5-Jul-01, to lugnet.general, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) As regard the math, I wouldn't know where to start, but surely even if the moon we're sitting on the earths surface the earth would still exert more force than the moon so you wouldn't be weightless. I don't know if you mean't, at the point (...) (23 years ago, 4-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| I should probably try to solve the problem myself, it'll help as prep for my college entrance exam. ;-) (...) Hmm, not bad at all - that gives people time enough to *realize* it's happening, broadcast it all over the world, and let everyone go (...) (23 years ago, 3-Jul-01, to lugnet.space, lugnet.off-topic.geek)
|
|
