pastvne
Bruce Decker
Hi All:
Assume I have a list with a text field that I convert to medium text at the MySQL level
Assume I have 750,000 rows in my database
Assume that when viewing the list, that I don't need the data in the medium text field
Assume that when viewing the list, that I don't need to 'search' based on content in my medium text field.
Now then, given these assumptions, would it be significantly faster when viewing the list if I create a 'viewable' list without the join of the medium text field then use a custom URL to the list with the join to the medium list when (and only when) I need to interact with the data in the medium text column?
I'm trying to come up with a way to get better performance for my largish table. In my other thread, I'm looking at MySQL partitioning. In this one I'm proposing to move the non-critical medium text into another table to try to improve the list view performance of the first list (without the join of the medium text).
I realize that Hugh and Rob are on project right now but I'm open to any suggestions as I'm getting to the point where I need to try something but I don't have a lot of time to waste on invalid ideas either.
Any advice from anyone would be appreciated.
Regards,
Bruce Decker
Assume I have a list with a text field that I convert to medium text at the MySQL level
Assume I have 750,000 rows in my database
Assume that when viewing the list, that I don't need the data in the medium text field
Assume that when viewing the list, that I don't need to 'search' based on content in my medium text field.
Now then, given these assumptions, would it be significantly faster when viewing the list if I create a 'viewable' list without the join of the medium text field then use a custom URL to the list with the join to the medium list when (and only when) I need to interact with the data in the medium text column?
I'm trying to come up with a way to get better performance for my largish table. In my other thread, I'm looking at MySQL partitioning. In this one I'm proposing to move the non-critical medium text into another table to try to improve the list view performance of the first list (without the join of the medium text).
I realize that Hugh and Rob are on project right now but I'm open to any suggestions as I'm getting to the point where I need to try something but I don't have a lot of time to waste on invalid ideas either.
Any advice from anyone would be appreciated.
Regards,
Bruce Decker