RE: [Slashcode-development] (no subject)

[Blake D. <bl...@ar...>]

For the newest solution, how are you keeping both tables replicated?  Will
slashd do this?

Thanks
Blake Day
CTO, SpunkNetwork
bl...@sp... <mailto:bl...@sp...>
home: (770) 338-1589
mobile: (678) 485-0519


-----Original Message-----
From: sla...@li...
[mailto:sla...@li...]On Behalf Of
Brian Aker
Sent: Friday, April 06, 2001 1:32 AM
To: sla...@li...
Subject: Re: [Slashcode-development] (no subject)


shane wrote:
> >Why does "newstories" even exist?
> I think it's to speed up the sql. If you've 2000 stories in the
> 'stories' table, and you've got the 10 latest stories in the
> 'newstories' table, then the db (for the majoriy of the hits
> to the system) only has to waid through those few in the
> newstories table, rather then polling the huge stories table.
That is exactly why it exists. We have a better solution
for 2.2 though for this. There will be three tables where
there was one. There will be a meta table holding all
non blob information for the site and a blob table
with the sid referenced to a blob.
Finally there will be a heap table that is a copy
of the meta table. Selects will be made against
table. This is incredibly fast and uses very little
memory.
Neat aye?
	-Brian
--
_______________________________________________________
Brian Aker, br...@ta...
Slashdot Senior Developer
Seattle, Washington
http://tangent.org/~brian/
http://slashdot.org/
_______________________________________________________
You can't grep a dead tree.

_______________________________________________
Slashcode-development mailing list
Sla...@li...
http://lists.sourceforge.net/lists/listinfo/slashcode-development