INDEXes grasshopper, INDEXes.
--On Sunday, June 13, 2004 11:26 -0700 David Blomstrom <[EMAIL PROTECTED]> wrote:
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]
-- Michael Loftis Modwest Sr. Systems Administrator Powerful, Affordable Web Hosting
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]