> Nic
>
> Good to see you working on the weekend - hah
>
that implies I work during the week.... :) seriously, tho, DUG stuff aint
usually work - it comes into my home account, hence on my own time.
> > well, can you do "proper" cascade deletes? ie, delete from the master
> table,
> > remove the children automatically?
>
> Declaritively not in 6.5 but in 2000 yes - but I use triggers to enforce
RI
> anyway so yes
so they added before triggers in 2000?
>
> > 2/ CASE, COALESCE and NULLIF (also ansi)
>
> Def ANSII
>
fair enough. I'll have to look up the spec again. google here I come.
> > MSSQL _does_ have a better function library tho - its rather nifty :)
>
> I think that was more my point than a 'decent' script language
>
I hope so, 'cos the scripting language (like IB's) is awful. I really hope
someone hacks Java or something in there - get a decient language with hooks
in to do things like get result sets and the like.
> > > 3/ User Defined Functions. (and don't say UDL's)
>
> No not xp's under 2000 you have UDF's
>
then whats a UDF under 2000? the ability to define something thats in the
select clause,eg select func(field) from whatever?
> > I think what most people on this list need is a light weight, low cost,
> > low maintenance database for projects which would have otherwise
> > used something like Paradox. IB fits that _perfectly_.
>
> So unfortunately does MSDE - and don't dump that small footprint dogma
> on me because at 64Mb ram at $75 and 15Gb disk at $200 it is irrelevant.
true, but you dont wanna upgrade your 50 workstations (5k$ of memory - $75
is dealer, I beleive, you gotta add markup :) ), or the fleet of salespeople
with otherwise functional laptops just to run one app - throws the cost up a
bit much (last project I looked at that was remotly legacy had to run on
anything from a PIII 750 desktop with 256meg to a 486 with 16meg and windows
95. There was no way of changing these requirements.
Besides, 64meg is not "small footprint" - it's what most people have
_total_, and thats usually hogged by the OS, sundry apps (virus checkers
etc) and other gunk before your app gets in there.
Can you install MSDE and forget it tho? From memory, you couldn't do that
with MSSQL, and as they are "the same".....
> You either
> pitch IB as a 'light weight, low cost, low maintenance database' ie
imbedded
> or as
> a serious contender in the C/S market but not both. Having worked with
both
> (prob a statement only you (nic) and I can make!) I hit brick walls in IB
> first.
Fair enough - I've worked with MSSQL (6.5 tho), IB and Oracle in production
environments. I dont think IB is a serious contender in the "C/S market", ie
with the BIG boys, which is basically Oracle and MSSQL at the moment (Sybase
has slipped off the map, and I'm not sure informix was ever really there -
Kerry, wanna jump in if you are still there?). I think IB is exceptional
when appilied to a small (<20 users on a single server), low maintenance or
highly volitile problem, eg automation, POS and most verticle market apps.
I'm getting scepticle about its ability to scale above about 50 users on
intel hardware - even in web situations, I've only ever once seen my initial
connection pool grow once (starts at 20), and that was under a load test.
OTOH, how many people out there are writing apps that are used by > 50
people _at_the_same_time_ and on the same database? Not many in NZ, I doubt
(lots of people with lots of deployed sites that have 100's of users, but
they all have their own DB's.)
The performance of any C/S DB, tho, depends on more than just the DB - the
way the app is coded is as much to blame as anything. I've used single user
apps that suck performance-wise 'cos they are badly coded.
Personally, I'm getting a little jaded about the whole OS
war/LinuxvrsWindows/DB War thing - its just getting stupid. While I wouldn't
put an NT box on the public internet, I'd definatly use it in most other
situations, tho I'd be more inclined to use Linux if it did the same job (Eg
mail), but only really 'cos its free. Every OS out there has its good and
bad points, and every developer has made trade-off's when they develop the
software - be it an editor, DB, OS, whatever. I've found the current crop of
MS OS'es (2000) to be unbeleivably stable and usable (given atleast 64meg
RAM). I definatly can't say the same for Linux - it still has that "hacked
together" feel about it.
I think Interbase _is_ good for what its designed for - it atleast what its
been marked as (embed, deploy, relax), but I have some reservations about it
in very large situations. Having said that, I know its in use in some really
big situations (200+ users, multi-gig DB's). I just dunno if _I_ would do
that myself. The NZ market is prefect for it tho - our "big" companies
(Telecom for eg) are really just medium-sized business's by US standards.
>
> Sidebar here - We are running into probs out there with disparate memory
> prices (for EDO
> SIMMs for example). A recent case $540 for 64Mb in EDO Simms or $75 for
64mb
> DIMM and
> $220 for a new Motherboard with 300Mhx AMD. Also I note that when we set
up
> Linux for
> firewalling and mail serving - it required 64Mb. Fun next week getting our
> first 1Gig Athalon
>
your actually _buying_ one? Personally, I wouldn't bother - you'll be
running windows 2000 or nt on it, right? so get a dual CPU machine instead -
a dual 700 should outperform a 1gig in _most_ multi-tasking situations,
without the ability to fry your breakfast on it.... Make sure you check the
cache multipliers before you get one - the PIII 1000mhz actually has a
slower cache than the 850, or something like that, so it actually gets
outperformed by the slower CPU - or atleast, the difference is not remotly
close to the price different.
> Kylix ie CLX for me is risk management - If you look at the tools that are
> coming out like QT/VNC and
> poss LBX I can see a definate alternative to MS/Metaframe/ICA for the ASP
> market,
I _gotta_ look these up! I think that could be a "killer" market for Linux -
server off in the data center, but with people running apps on it ala
Terminal Server. Could be a good option.....
> They are both similar tech's and where the slugfest will be in the next
few
> years,
> Kylix is perfect because it supports both and has and IDE and is nice to
> write....
true, very true - but technically, do does Delphi 6, but its "old tech", so
noone is hypeing it, which is a pity, 'cos its still a good product. Gonna
be an interesting 6 months, methinks.
> Have a good saturday night
it'll be a quiet one - had a fairly large one last night - running on 5
hours of bad sleep :) was worth it tho.
N
---------------------------------------------------------------------------
New Zealand Delphi Users group - Delphi List - [EMAIL PROTECTED]
Website: http://www.delphi.org.nz
To UnSub, send email to: [EMAIL PROTECTED]
with body of "unsubscribe delphi"
