1. databases and cpu speed
greetings again,
Has anyone run a database engine on one puter, and transfered it over to a
faster
puter, and found a noticeable difference in access times? Has the speed increase
been due to faster cpu or faster harddrives? Do you have benchmark times? And
most
importantly, was the database written in Eu (compiled or interpretted?), and was
it
doing any string manipulation like searching or find()s in the data before
returning it?
My fastest puters are 266Mhz and 300Mhz, but there are now surplus 600Mhz puters
on sale for $300......
Kat
2. Re: databases and cpu speed
- Posted by leviathan at uswest.net
Mar 04, 2001
> greetings again,
>
> Has anyone run a database engine on one puter, and transfered it over to a
> faster
> puter, and found a noticeable difference in access times?
The example I have for this is the deal I'm working on,
Napster:Parse, file access to a 1360-record database is snappy on
either the Celeron 466 (abit), or the Pentium 266 (mtech). However,
access to a window has a considerable difference, like where I have
to add this 1360-file list to a LV, the mtech is very much slower at it
than the abit is. Amazing, really.
> Has the speed increase
> been due to faster cpu or faster harddrives? Do you have benchmark times? And
> most
> importantly, was the database written in Eu (compiled or interpretted?), and
> was it
> doing any string manipulation like searching or find()s in the data before
> returning it?
Yeah, sure, both the mtech and abit are anywhere from two or three
generations apart in all their components, so yeah, things have a
difference.
However, I don't bother to make a benchmark for any of this, I'm just
writing a program to work across win9x systems... I don't particularly
care about the target system (except if it works on these Win9x
boxen, it should work anywhere)
>
> My fastest puters are 266Mhz and 300Mhz, but there are now surplus 600Mhz
> puters
> on sale for $300......
>
Snatch them thangs up, Kat! Time for a cluster for Tiggr, with that
price! :)
--"LEVIATHAN"
3. Re: databases and cpu speed
- Posted by Ted Fines <fines at macalester.edu>
Mar 04, 2001
-
Last edited Mar 05, 2001
I developed an EDS db on a Windows P133 system, then ran it it in
production on a Windows PII 233 ssytem. It is many many times faster.
Record insertion times are far faster. The db is about 2400 records of
about 9 sequences per record.
Ted
--On Sunday, March 04, 2001 11:58:38 AM -0800 Kat <gertie at PELL.NET> wrote:
> greetings again,
>
> Has anyone run a database engine on one puter, and transfered it over to
> a faster puter, and found a noticeable difference in access times? Has
> the speed increase been due to faster cpu or faster harddrives? Do you
> have benchmark times? And most importantly, was the database written in
> Eu (compiled or interpretted?), and was it doing any string manipulation
> like searching or find()s in the data before returning it?
>
> My fastest puters are 266Mhz and 300Mhz, but there are now surplus 600Mhz
> puters on sale for $300......
>
> Kat
>
>
