Phpmyadmin

[MarcusZ]

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

[Mchl]

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.

[MarcusZ]

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?

[Mchl]

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.

[metalaarif]

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.