Re: Data Modelling

2008-05-13 Thread Krishna Chandra Prajapati
then the trigger also will > > > have > > > to wait, till the locks on the main table are released. > > > > > > This trigger would add another feather to the lock/load on the > > > machine. > > > > > > regards > > > anandkl > >

Re: Data Modelling

2008-05-13 Thread Ben Clewett
main table, then the trigger also will have to wait, till the locks on the main table are released. This trigger would add another feather to the lock/load on the machine. regards anandkl On 5/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: Hi, Generally, in data modelling th

Re: Data Modelling

2008-05-13 Thread Krishna Chandra Prajapati
3/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > > > Hi, > > > > Generally, in data modelling there are some independent table, user > > related > > tables, master tables and one main table which is related with most of > > the > > ta

Re: Data Modelling

2008-05-13 Thread Krishna Chandra Prajapati
; Other than that you can split your tables into smaller ones using either > partitioning or the federated engine... > > Ben > > > > > > Krishna Chandra Prajapati wrote: > > > Hi, > > > > Generally, in data modelling there are some independent table, u

Re: Data Modelling

2008-05-13 Thread Ben Clewett
If you use InnoDB you should not have a problem as it used row-level locking and isolated transitions. Other than that you can split your tables into smaller ones using either partitioning or the federated engine... Ben Krishna Chandra Prajapati wrote: Hi, Generally, in data modelling

Re: Data Modelling

2008-05-13 Thread Ananda Kumar
5/13/08, Krishna Chandra Prajapati <[EMAIL PROTECTED]> wrote: > > Hi, > > Generally, in data modelling there are some independent table, user > related > tables, master tables and one main table which is related with most of the > tables. Almost in all the queries main tab

Data Modelling

2008-05-13 Thread Krishna Chandra Prajapati
Hi, Generally, in data modelling there are some independent table, user related tables, master tables and one main table which is related with most of the tables. Almost in all the queries main table is involved to fetch the `id`. In this way main table is used maximum. some times the main table

Data modelling tool

2003-10-29 Thread Hardik Doshi
Hi Group, Sorry i am posting the same message asking about data modelling tool. I am looking for the best data modelling tool for the mysql 4.0 dbms. Specifically i am looking for the generalization/specialization relationship support within the tool. Thanks in advance. Hardik

Data modelling software

2003-10-23 Thread Hardik Doshi
Hi Group, I am looking for the data modelling tool which should incorporate the generalization/specialization feature of database design. Does anyone know better tool for it? So far i have tried datanamic and case studio but none of them has above mentioned feature. Thanks Hardik Doshi

Re: Data modelling software

2003-10-20 Thread Cal Evans
k Doshi [mailto:[EMAIL PROTECTED] Sent: Monday, October 20, 2003 12:42 PM To: [EMAIL PROTECTED] Subject: Data modelling software Hi Group, Can anyone tell me which data modelling software is good for the mysql database? Thanks Hardik - Do you Yahoo!? The New

RE: Data modelling software

2003-10-20 Thread Hardik Doshi
, October 20, 2003 12:42 PM To: [EMAIL PROTECTED] Subject: Data modelling software Hi Group, Can anyone tell me which data modelling software is good for the mysql database? Thanks Hardik - Do you Yahoo!? The New Yahoo! Shopping - with im

Data modelling software

2003-10-20 Thread Hardik Doshi
Hi Group, Can anyone tell me the best software for data modelling? I want to draw the ER diagram for the new system as well as existing system. Thanks Hardik - Do you Yahoo!? The New Yahoo! Shopping - with improved product search

Data modelling software

2003-10-20 Thread Hardik Doshi
Hi Group, Can anyone tell me which data modelling software is good for the mysql database? Thanks Hardik - Do you Yahoo!? The New Yahoo! Shopping - with improved product search