Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.tools -> Re: how to implement a planing application

Re: how to implement a planing application

From: Frank <frankbo_at_interaccess.nl>
Date: Thu, 28 Sep 2000 08:53:34 +0200
Message-ID: <8quqcu$3am$1@porthos.nl.uu.net>

Give it a try; 800k recors is not that much...

--
Frank
Arnold Douma <douma33_at_zonnet.nl> schreef in berichtnieuws
ayNz5.5270$tL4.113732_at_zonnet-reader-1...

> Can someone give me a database model for the next problem:
>
> There are persons (app 25) with individual working schedules. Within these
> schedules there have to be planed appointments. These appointments are
> segments of 10 min. long.
>
> How can i make a structure to implement this?? Just making a table with
> available time is an idea, but the database is getting realy big by that.
I
> have to keep appointments of the past AND the future year. This is going
to
> be a table with app 25 (persons) * 48 (timedivisions per day) * 365 (days
> per year) *2 (previous and next) = 876000 records!!!! So by a table of
this
> size, the response time is going to be a realy coffebreak.....
>
> Every solution or idea is welcome!!!!
>
>
Received on Thu Sep 28 2000 - 01:53:34 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US