I wouln't dream of splitting 10mill records into 10,000 tables. IB/FB
wouldn't show any real performance difference but seondly, the management
issue of creating either 10,000 queries everytime I need one (i.e. each with
there own table name or doing code to manually create the query to use 1 of
10,000 tablenames would be very unprofessional.

Alan

-----Original Message-----
From: German Terrazas [mailto:german@...]
Sent: Thursday, 6 March 2003 3:14 AM
To: ib-support@yahoogroups.com
Subject: RE: [ib-support] Creating Tables Problem



10,000 details by 1000 masters = 10,000,000 records in only one
table.

On Wed, 5 Mar 2003, Richard Pendered wrote:

> Speed would not be an issue if you define you keys correctly, so you only
> need 1 detail table.
>
> -----Original Message-----
> From: German Terrazas [mailto:german@...]
> Sent: 05 March 2003 16:03
> To: ib-support@yahoogroups.com
> Subject: RE: [ib-support] Creating Tables Problem
>
>
>
> yes it does.
>
> the restriction for performance is: it is required to create a
> new detail table for any new master record.
>
>
> thanks,
> german
>
>
> On Wed, 5 Mar 2003, Richard Pendered wrote:
>
> > Sounds like a classic master detail relationship to me
> >
> > -----Original Message-----
> > From: German Terrazas [mailto:german@...]
> > Sent: 05 March 2003 15:51
> > To: ib-support@yahoogroups.com
> > Subject: Re: [ib-support] Creating Tables Problem
> >
> >
> > Hi Martijn,
> >
> > The problem is as follows:
> >
> > I have a table A with records referencing to a table. The problem I
> > have is that for any new record of A it is necesary to create a table
Aj.
> >
> > I can obtain the name of the new table by string concatenation and pass
> > the name to a stored procedure. But, that stored procedure cannot
perform
> > a create table.
> >
> > My solution is to pass the createTable query string to a delphi
> > DB component. I think it is better to reach a more deployment platform
> > independent solution.
> >
> > Any other idea to do that ?
> >
> > thanks !
> > german
> >
> >
> >
> >
> > On Wed, 5 Mar 2003, Martijn Tonies wrote:
> >
> > > German,
> > >
> > > > Firebird do not allow:
> > > >
> > > > [1] execute 'select * from table' or execute :varstr where :varstr
is
> a
> > > > varchar containing a sql statement.
> > >
> > > Luckily, Firebird 1.5 - now being tested as a beta - does support
this.
> > >
> > > > [2] dynamic table creation
> > >
> > > Ugh - WHY do you need this? Then, we'll talk about better or other
> > > ways to solve this.
> > >
> > > > So, I think firebird is not a profesional sql engine for me to
deploy
> > > > with.
> > >
> > > Because you can't solve your own problems and you're stuck in a
> > > particular way of thinking, you are telling us that Firebird isn't
> > > professional?
> > >
> > > Read the docs, ask questions - and we can help. Don't complain about
> > > things that cannot be done - or you haven't asked anything about.
Let's
> > > be a little more constructive than that - and you will see that
Firebird
> > > is a VERY professional database engine.
> > >
> > >
> > > --
> > > Martijn Tonies
> > > Upscene Productions
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > ib-support-unsubscribe@egroups.com
> > >
> > >
> > >
> > > Your use of Yahoo! Groups is subject to
> http://docs.yahoo.com/info/terms/
> > >
> > >
> > >
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
> > To unsubscribe from this group, send an email to:
> > ib-support-unsubscribe@egroups.com
> >
> >
> >
> > Your use of Yahoo! Groups is subject to
http://docs.yahoo.com/info/terms/
> >
> >
> >
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>



To unsubscribe from this group, send an email to:
ib-support-unsubscribe@egroups.com



Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/