|
|
 | | Re: Couldn't resist
|
| (...) What's the deal with that Shiri person? She never has a bad thing to say about anyone, she's always got some positive contribution to make, and her posts are uniformly well-reasoned. I'm tired of her consistency and good-spiritedness--she's (...) (23 years ago, 6-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) Jesse, What does this have to do with the current thread? I also hope that you are joking (in which case you should be posting to .fun). Shiri is a good builder and a large contributor to the community. I'm a little confused as to where this (...) (23 years ago, 6-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) Am I evil or annoying, Shiri? I am simply wanting to know and I want to know if you have built any LEGO sets of your own in your spare time. (We are evil! In-deed! Kaientai, WWF) Jesse Long (23 years ago, 6-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Gallery speed
|
| (...) I'd go for amalgamating the two steps into one query - something like: SELECT id, name, icon_information, etc. FROM file_parent WHERE file_parent.id IN (SELECT file_parent from files) This avoids the problem of having to query for DISTINCT (...) (23 years ago, 6-Jul-01, to lugnet.off-topic.geek)
| | | | | Re: Gallery speed
|
| (...) This probably wouldn't help much - the cursor isn't indexed, so the SELECT DISTINCT would be slow. A better way to split it (assuming your back-end has a decent optimiser) may be to create an index on file_parent + file_modify_time, then do: (...) (23 years ago, 6-Jul-01, to lugnet.off-topic.geek)
| | | | | 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)
| | | | | Re: Couldn't resist
|
| (...) I get 1 hour, 13 minutes. Or 2 hours, 26 minutes. If I could remember the derivitive of y = x^2, I'd be more precise. Steve (23 years ago, 2-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) I have two questions to ask now because of the replies to this bulletin board message I sent in response to many other messages on the Lugnet Space bulletin board room. The first question is for Kyle D. Jackson and Jeff Jardine and it is if we (...) (23 years ago, 2-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) I understand now in my mind that atoms are what makes the structure of all living organisms and the structure of all living organisms depends on the density and class of materials in the constructuion of space craft. It is obbvious to me that (...) (23 years ago, 2-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) I never spotted this before, but it's further proof that there's negligible friction in space. If there was, the Moon would have slowed down in it's orbit and fallen to Earth, and the Earth would slow down and fall into the sun. Actually, I (...) (23 years ago, 2-Jul-01, to lugnet.space, lugnet.off-topic.geek)
| | | | | Re: Couldn't resist
|
| (...) I didn't necessarily mean in space. I was just talking about liquids in general (on Earth, in an atmosphere). Clearly if you're trying to push your way through something, a gas is easier than a liquid, which is easier than a solid. But, this (...) (23 years ago, 2-Jul-01, to lugnet.space, lugnet.off-topic.geek)
|
|
