nathanelrick wrote:

>> I think you also mentioned that Ebay doesn't allow joins and uses the
>> > application to do the joining. If that's the case, I'm glad I don't work
>> > for Ebay. I'll be willing to bet that the Ebay application is written in
>> > Java - that sounds like the sort of thing that the Java developers (and
>> > vendors) I come into contact always do, treat the database as a bit
>> > bucket and reinvent the wheel - caching results, joins, referential
>> > integrity, check constraints etc.
> http://www.addsimplicity.com/downloads/eBaySDForum2006-11-29.pdf
>
> No business logic in database
> no stored procedure
> only very simple triggers (default population)
>
> Move CPU intensive work to applications
> Referential integrity
> joins
> sorting
>
> Extensive use of prepared statements and variables
>
> and yes you are right they move their C++/ISAPI to JAVA:) by the way that a curious choice ...

Not as curious as switching to IIS in 1999? That is probably a good explanation
on why they ended up having to move to Java. Where would their system be today
if they had simply stuck with unix/linux based system :) Although I believe
their search side is still unix based?

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php