Silicon Investor - Welcome New SI Members! Message Board

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.

SI - Site Forums : Silicon Investor - Welcome New SI Members!

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next

To: Green Receipt who wrote (18918)	6/27/2003 1:15:51 AM
From: SI Bob	Read Replies (1) of 32873

I haven't really cared enough to find out, but my uneducated and barely-exposed guess is that a blob holds binary data (like images) and a clob holds a nearly limitless amount of character data. I could be way off-base, but it's my guess. Similar to SQLServer's Text fields or what I remember as Memo fields in other databases. I'll be really curious to find out, but I'm "guessing" that even with the enormous amount of data involved, by doing searches on a separate very powerful box, the fact that the cache hits would be relatively low might be a non-issue. Search is something most people can tolerate a bit of a wait for. I'd call anything less than 5 seconds to be more than acceptable performance, and that might be possible with tons of fast memory, very fast processors, and very fast hard drives. Basically another Dell 4600. Will a Codebase driver improve performance on subsequent hits even on a dynamic database? Will the existence of new messages with "INTC" in them make each retrieval basically a "first" one?

Report TOU Violation

Share This Post

Public Reply Prvt Reply Mark as Last Read File

Previous 10 Next 10 Previous Next