Silicon Investor, under the hood | Stock Discussion Forums

STOCKTALK

We've detected that you're using an ad content blocking browser plug-in or feature. Ads provide a critical source of revenue to the continued operation of Silicon Investor. We ask that you disable ad blocking while on Silicon Investor in the best interests of our community. If you are not using an ad blocker but are still receiving this message, make sure your browser's tracking protection is set to the 'standard' level.

Pastimes
Silicon Investor, under the hood

An SI Board Since December 2004

Posts	SubjectMarks	Bans
81	21	0

Emcee: SI Bob	Type: Moderated

Introduction Compact

Go to reply# or date (mm/dd/yy):

Reply	Message Preview	From	Recs	Posted
31	Our database server runs Windows Server 2003, Enterprise Edition. In trying to	SI Bob	-	12/16/2004
30	<i>When I first asked about this, your stated preference was that everythi	SI Bob	-	12/15/2004
29	Close enough for our purposes.	SI Bob	-	12/15/2004
28	<i>>> I got a server error when I tried to do a search on a subject	SI Dave	-	12/14/2004
27	<i>>>Messageid runs in the same order as date_created. </i> E	SI Dave	-	12/14/2004
26	Wow, just found this board. <i>>But a pet peeve of mine (reading this,	SI Dave	-	12/14/2004
25	If I were doing that as a way to use LIKE rather than CONTAINS(), I wouldn't	SI Bob	-	12/14/2004
24	Bob, <i> just did a full-text search there and after playing with iHub	Joe NYC	-	12/14/2004
23	<i>I don't have the figures, but I think "seconds" is what B	SI Bob	-	12/14/2004
22	<i>In case you were interested, I got a server error when I tried to do a	SI Bob	-	12/14/2004
21	That likely wouldn't help subject-specific searches at all because even with	SI Bob	-	12/14/2004
20	investorshub.com I think iHub's search is going to get a rewrite. Far smal	SI Bob	-	12/14/2004
19	mas, I don't have the figures, but I think "seconds" is what Bob	Joe NYC	-	12/13/2004
18	75 Mb of data read from disc is not a big deal, can be done in seconds, it's	mas_	-	12/13/2004
17	bob, In case you were interested, I got a server error when I tried to do a sea	Joe NYC	-	12/13/2004
16	mas, and you would do this to be able to do a sequential read of the records, a	Joe NYC	-	12/13/2004
15	Well subject/threadid would have very few values ;-). It's a big change thou	mas_	-	12/13/2004
14	<i>Is the primary key a clustered index as that will be a mistake.</i&g	SI Bob	-	12/13/2004
13	<i> The primary key is messageid, and there are separate indexes for autho	mas_	-	12/12/2004
12	<deleted>	InternetPlay	-	12/12/2004
11	Actually, date_created is one of those fields that would only be helpful to inde	SI Bob	-	12/12/2004
10	I don't mind doing things the hard way. It's kind of a philosophical th	SI Bob	-	12/12/2004
9	<i> Thread id/author wouldn't be unique, which a primary key must be.	mas_	-	12/12/2004
8	<i>make sure the index is built on subjectid first, and then the message f	SI Bob	-	12/12/2004
7	<i>The bit I am not clear on is why MSSearch needs to be called. Can you n	SI Bob	-	12/12/2004

Go to reply# or date (mm/dd/yy):