-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Greg,
As you've seen there @ stirlingbridge, you can have a properly
indexed and tuned database perform lookups rather quickly on tables
of any size, 2 million to 245 million.
I think the issue is not CF or any application server platform but
one of database design and architecture. CF, ASP, PHP, JSP... they
all in some way or another are going to be talking to a Oracle or
SQL, hopefully through a stored procedure.
Why would CFLOCK come into this?
Aaron Johnson, MCSE, MCP+I
MINDSEYE, Inc.
<phn>617.350.0339
<fax>949.350.8884
<icq>66172567
[EMAIL PROTECTED]
___________________________________________
"Never forget that only dead fish swim with
the stream." -- Malcolm Muggeridge
___________________________________________
- -----Original Message-----
From: Gregory Harris [mailto:[EMAIL PROTECTED]]
Sent: Wednesday, December 13, 2000 12:13 PM
To: CF-Talk
Subject: Re: Just a stray thought
Oh, and I forgot:
Remember most of this is at peak time (who cares where their package
is at
3am, except for UPS themselves?), I figure, 300 people hitting at any
given
instant is to be expected. CFLOCK can't handle that many alone.
Also the
database could be larger (if you could track from the last year,
figure 1
billion records maybe?)
I hate to say this, Toys R Us only wishes they had 300 people on the
site at
a given instant (even if they did, the queries for some of the stuff
doesn't
have to be realtime and they can cache stuff), and they don't have 1
billion
products to offer. Plus the queries being in Realtime (or close to
it,
small expiration dates a must). Again, any takers?
Gregory Harris
Web Developer
Stirling Bridge Group LLC
- ----- Original Message -----
From: "Greg Creedon" <[EMAIL PROTECTED]>
To: "CF-Talk" <[EMAIL PROTECTED]>
Sent: Wednesday, December 13, 2000 8:46 AM
Subject: RE: Just a stray thought
> I bet the guy who worked on toysrus and who was at the ny cf users
> group last night would have some ideas on this!
>
> btw, a round of applause and thanks to the Dinowitz family and Greg
Nahrain
> and others who put on the meeting last night under difficult
> circumstances (tight space!). And I'm not just saying this since I
> won a copy of the Fusebox book!
>
> -----Original Message-----
> From: Gregory Harris [mailto:[EMAIL PROTECTED]]
> Sent: Wednesday, December 13, 2000 11:36 AM
> To: CF-Talk
> Subject: Just a stray thought
>
>
> Ok, this is meant as no shameless plug but I read on their website:
>
> UPS expects to receive 5 million tracking requests on their website
> per
day
> especially on their peak days (it reads something like that)
>
> Your mission: build a Cold Fusion application for UPS that could
> handle
such
> a beating, how would you do this? Bear in mind:
>
> 1) You will have to search through a database of approximately 245
> million records (packages delivered)
>
> 2) 5 million per day equals 60 per second, transactional integrity
> has to
be
> TIGHT!
>
> 3) Money is no real object (UPS needs this to work some how, but be
> realistic in terms of "what you get is what you pay for")
>
> Who's up for this?
>
> Gregory Harris
> Web Developer
> Stirling Bridge Group LLC
>
>
>
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
