MZ wrote:
> Hello!
>
> I have heard lately that when sb has very big mysql database and call delete
> sql query many times on this database it generates many gaps in database.
> That`s why database store a big space on hardware and can work lower. Is it
> true?
>
> Moreover, I have heard that in this case there is a need to compact database
> (from time to time) to fill/remove gaps and this will make such database
> more efficient. How to do that in phpmyadmin? Is it a thing which has to be
> done by admins? Should I do it by myself? If so, how can I do this in
> phpmyadmin? Should I take care for some things - which then?
>
> Thank you a lot
> Marcin
>
>

it's good practice to reorg your table periodically specifically to
overcome the "gap" problem you're talking about.

as far as phpmyadmin, i am not sure but i think i've seen a button
somewhere to run table optimization commands. maybe ask phpmyadmin folks!