Gossamer Forum
Home : Products : Gossamer Forum : Discussion :

New Messages..

Quote Reply
New Messages..
Can you let me know if you see anything strange with new messages on the main page or a category page? We adjusted the logic quite a bit to speed things up.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] New Messages.. In reply to
fast !!! zoooommmmm

openoffice + gimp + sketch ... Smile
Quote Reply
Re: [QooQ] New Messages.. In reply to
127 SQL queries down to 5. =)

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] New Messages.. In reply to
127 per page?
Quote Reply
Re: [RedRum] New Messages.. In reply to
On the main page only, yes.. actually bad math, 4 per forum * 27 forums = 108.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] New Messages.. In reply to
Wow I was getting worried when I had 5 queries in one routine in a script I was writing lol
Quote Reply
Re: [RedRum] New Messages.. In reply to
MySQL is very fast. A properly indexed query even on a large database can take less then 0.001 second. When you consider that to even launch perl and compile your program, you are talking 0.2seconds, the time required for running queries is pretty minimal.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] New Messages.. In reply to
>>A properly indexed query <<

But would that just be for searches?

What about selects/updates etc?
Quote Reply
Re: [RedRum] New Messages.. In reply to
No, that would be anything with a WHERE clause.

Cheers,

Alex
--
Gossamer Threads Inc.
Quote Reply
Re: [Alex] New Messages.. In reply to
...and does that 0.001 increase a lot/little if you are grabbing large amounts of rows vs small amounts?

Last edited by:

RedRum: Dec 19, 2001, 4:27 PM