MySQL Forums
Forum List  »  Performance

Advanced Search
New Topic

Re: large multiple table update taking a very long time, help!
Posted by: Jason Hines
Date: April 19, 2009 07:59AM

Sorry, to answer your question about what fields I have to select, essentially I need to select all the fields from table3 given a class_id ... including the text fields. That's why I currently have them thrown in a single table. I found joins to be very slow with large tables. I also need to select rows based on id as well (primary key) for some other cases.

What would be the effect of switching the text fields to a varchar with an arbitrarily large size?

Navigate: Previous Message• Next Message
Options: Reply• Quote


Subject
Views
Written By
Posted
large multiple table update taking a very long time, help!
5200
Jason Hines
April 18, 2009 05:08PM
Re: large multiple table update taking a very long time, help!
2313
Rick James
April 18, 2009 06:18PM
Re: large multiple table update taking a very long time, help!
2608
Jason Hines
April 18, 2009 08:36PM
Re: large multiple table update taking a very long time, help!
2245
Jason Hines
April 18, 2009 08:39PM
Re: large multiple table update taking a very long time, help!
2246
Jason Hines
April 19, 2009 07:59AM
Re: large multiple table update taking a very long time, help!
2595
Rick James
April 19, 2009 11:50AM
Re: large multiple table update taking a very long time, help!
2906
Jason Hines
April 19, 2009 12:45PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.