On 23 Sep 98, at 9:09, Rich Kulawiec wrote:
> A "few thousand items"? You don't *need* a database. Your data set is
> far too small to justify one. They're expensive, they eat resources,
> they're tough to interface with (if you can), they (usually) take
> training to use. And commercial ones are black boxes: you can't
> reach inside to fix it if it's broken, but instead have to wait
> for support (a bad industry-wide joke) to do it for you.
> It's far simpler to store these items in a plain old flat ASCII file
> and search it brute-force. If you need more speed, cause it to
> be memory-mapped. If that's still not enough, then make it an
> associative array, or put N copies of it in memory, where "N" is
> the number of different fields you need to search by.
> Why? Because CPUs are incredibly fast, memory and disk are available
> in huge quantities, and all three are getting cheaper by the month.
> If the combination of those three resources is not already sufficient
> to meet the performance requirements -- using a brute force solution --
> it probably will be in the very near future. And tying the solution
> to Moore's law guarantees you a healthy amount of scalability, even
> assuming zero improvement in the s/w or OS.
YEAH... I don't know If this is the right spelling for expressing
"solidariety" and approvation...
Text files... eheheh 20 fields x 1000 records x 255 bytes per fields
= 5Mb about 1/12 of the memory on a today server!!!
64Mb cost about 100$... How much does it cost Access???
If you think windows has 200Kb .DLL and it continue to
Load/Unload them from disk ???
Yes we are trapped. I'm one of the trapped people... but I'm
planning a "soft", unpainful escape :-)
-------------------------------------------
Ivan Sergio Borgonovo [EMAIL PROTECTED]
Webmaster Gorilla Bookstore http://www.gorilla.it
Tel. +39 2 3311105/34530455 Fax. +39 2 34531591
Via Mac Mahon 9, Milano, Italy
-------------------------------------------
____________________________________________________________________
--------------------------------------------------------------------
Join The Web Consultants Association : Register on our web site Now
Web Consultants Web Site : http://just4u.com/webconsultants
If you lose the instructions All subscription/unsubscribing can be done
directly from our website for all our lists.
---------------------------------------------------------------------
