Any new Technique for joining too many tables ?

[cristinaemerson]

---

Hello friends,

I am currently developing a website, there are 413 tables that i have to join it .


so is there any technique to join all tables smartly...

[stealthghost]

MySQL Join
SQL Joins

[cristinaemerson]

413 tables to join? seems like a design issue. look into stored procedure. Also, do a lazy load for info/data not needed on loadtime, with 413 tables, am sure your page load time will be outrageous.

yes , you are right ethanium, tell me what cai do for this,
i am using stored procedure..

[ondoy]

pwede mag ask y ni abot ug 413 tables?..e try daw populate atleast 1k data kung dba mgcrash

[cristinaemerson]

pwede mag ask y ni abot ug 413 tables?..e try daw populate atleast 1k data kung dba mgcrash

Hey Ondoy i can`t understand your language,
would you like to tell this in ENGLISH..

[ondoy]

oh sorry, just want to ask how did it come to 413 tables,is this an ecommerce site?..have you tried populating the tables to at least 1k entries, did it break your DB?

[sanggano_boy]

It's apsolutely rubbish! sorry for that, hehe
The question you need to ask, Am I going to use all the fields of 413 tables at once?
Can a single user view all fields of the 413 in a single transaction?

If the record gets big, you'll have a performance issue and worst db crash.

1. Try to simply your database design.
2. Use record paging connected to a stored procedure.

Hope it helps PM if you still need more

[chrisvil]

Try using normalization...

[gwenharold]

TS ask ako amigo if tanan jud bah ang 413 tables e join? Or basin few numbers ra e join?

[simoncpu]

Hello friends,

I am currently developing a website, there are 413 tables that i have to join it .


so is there any technique to join all tables smartly...

You're asking the wrong question Ms. Cristina. The correct question is: how can you make your website work with 5-20 tables only?