|
|
 | | 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)
| | | | | Re: Couldn't resist
|
| (...) Actually, when calculating the acceleration and taking the distance into account, it's not so bad. For my first attempt at solving this, I tried converting gravitational potential energy into kinetic energy. The resulting integral was (...) (23 years ago, 3-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) Umm... It's not a poke. honest. Your value for the Earth-moon distance is off by a factor of ten. which means your answer should be 2.25ish days. And... The force of the moon's gravity doesn't really enter into this. We know Force = (...) (23 years ago, 3-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) Calculus, yet another form of mathematics that I am unable to do in my life. Jesse Long (23 years ago, 3-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) Then it should be 2:26. Assuming that the relative acceleration between the Earth and the Moon is the sum of their local accelerations due to gravity. And assuming that acceleration is directly proportional to the force of gravity. Ie, when (...) (23 years ago, 3-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) That'd be dy/dx = 2x. (I knew that calculus'd come in handy one day!) ROSCO (23 years ago, 3-Jul-01, to lugnet.space, lugnet.off-topic.geek)
|
|
