MarcusZ Posted June 14, 2010 Share Posted June 14, 2010 Hello, I have two questions about phpmyadmin.com . First of all it loads very slowly in my browser, is there a way to speed things up? Is it possible to set a standard order in the table, because my tables are all in very strange orders? thanks Quote Link to comment https://forums.phpfreaks.com/topic/204711-phpmyadmin/ Share on other sites More sharing options...
Mchl Posted June 14, 2010 Share Posted June 14, 2010 InnoDB tables are by default ordered by primary key (unless there's no such key defined) To set default order for MyISAM: ALTER tableName ORDER BY columnName although this will only order records already in the table. Any new records will not be ordered until you run this query again. Quote Link to comment https://forums.phpfreaks.com/topic/204711-phpmyadmin/#findComment-1071827 Share on other sites More sharing options...
MarcusZ Posted June 15, 2010 Author Share Posted June 15, 2010 Thank you for your answer. That is the problem, all the new data isn't ordered correctly. I have a column with the timestamp, is it possible to make it standard order in the table for all new data as well? Quote Link to comment https://forums.phpfreaks.com/topic/204711-phpmyadmin/#findComment-1072316 Share on other sites More sharing options...
Mchl Posted June 15, 2010 Share Posted June 15, 2010 No it is not. If the table is fragmented, MyISAM will put new rows into vacant spaces where deleted rows were. Why would you care anyway? You should order your queries anyway to avoid ambiguity. Quote Link to comment https://forums.phpfreaks.com/topic/204711-phpmyadmin/#findComment-1072559 Share on other sites More sharing options...
metalaarif Posted June 16, 2010 Share Posted June 16, 2010 Hello, I have two questions about phpmyadmin.com . First of all it loads very slowly in my browser, is there a way to speed things up? Is it possible to set a standard order in the table, because my tables are all in very strange orders? thanks hey i'm not so super good at php but i was having same probs, i had no idea, so i unistalled it and then and reinstalled, that solved my prob, if that doesn't do then you should have virus in PC which is slowing your browser to load from localhost, even just to browse phpmyadmin.. i might not be much help but it worked for me. Quote Link to comment https://forums.phpfreaks.com/topic/204711-phpmyadmin/#findComment-1072987 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.