I have a MySQL table with about 3,500 rows and 30 columns. There are rows for each of the world's nations, each of the 50 states, some 3,000 U.S. counties, Canada's provinces, etc. Obviously, I can't display the entire table on a web page.
But even when I do an operation that displays just a single cell, it takes a long, long time to load. So I'm thinking of splitting the table into three tables - Nations, States and Counties. But I wanted to make sure I'm not doing something wrong first. I thought dynamic tables were supposed to process very quickly and that the loading time was associated primarily with the amount of data you want to display on a page. Am I wrong? __________________________________ Do you Yahoo!? Friends. Fun. Try the all-new Yahoo! Messenger. http://messenger.yahoo.com/ -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]