4
Contributors
4
Replies
5
Views
7 Years
Discussion Span
Last Post by kylegetson
0

What is the table structure you are using and are all 62 tables of the same design? Its hard to talk about efficiency without understanding how the tables are constructed.

0

What is the table structure you are using and are all 62 tables of the same design? Its hard to talk about efficiency without understanding how the tables are constructed.

Yeah, all 62 are of the same design, same structure, even the same fields (date, user, url, short_url).

1

would it not make more sense to have all this data in 1 table? if your table names are literally differentiated by a number, just add a field to your table structure. So instead of having 62 tables, have 1 table with the following fields:
date, user, url, short_url, TableNumber

Then you can have 1 simple, quick query to get what you need.

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.