Hi,
SHOW DATABASES seems somehow slow on ISPs
how about using I_S.SCHEMA_PRIVILEGES
f.e.
SELECT *
FROM `SCHEMA_PRIVILEGES`
LIMIT 0 , 30
performs much faster on the ISP i could test:
0.08 sec vs. 0.24 seconds
possible this will only work with ISPs where are no anonymous rights
possible a configuration where ISP can use I_S.SCHEMA_PRIVILEGES instead of
SHOW DATABASES, or they can switch to SHOW DATABASES like '[user]_%' which
performs much faster too
how about
$cfg['DatabaseListQuery'] = 'SHOW DATABASES';
// #user# is replaced by curent user
$cfg['DatabaseListQuery'] = "SHOW DATABASES LIKE '#user#%'";
$cfg['DatabaseListQuery'] = 'SELECT DISTINCT TABLE_SCHEMA FROM
`SCHEMA_PRIVILEGES`';
--
Sebastian
Hi,
we got a few requests about this. Probably the most common generator of
CSV files is MS Excel, and this fine application, when saving as CSV,
generates a semi-colon separated file with no possibility of specifying
the enclosing character (at least in the default dialog, I did not dig
everywhere).
But phpMyAdmin refuses to import it (see subject). I deactivated the
message in my copy of PMA then imported some simple sample data
Marc;1
Luc;2
(removing the double quotes in the CSV dialog), it went fine so I am
tempted to get rid of this validation but would like to hear your comments.
Marc
Hi Michal,
can you add some red bold blinking screen filling hint on the edit pages
that this is not the right place to ask questions about phpMyAdmin?
they should use the ways mentioned on http://wiki.cihar.com/pma/Getting_Help
--
Sebastian
Your document.
--------------------------------------------
website.zip: No virus found
Powered by the new Norton OnlineScan
Get protected: www.symantec.com
Hi
as an example for export plugins, I hacked export to Texy![1] format.
However now I can not decide whether it is worth of inclusion in
phpMyAdmin. You can see sample output in Texy! demo[2] (textarea
contains exported text, bellow it is rendered by Texy!).
What do you think? Should I commit it or not? :-)
[1]:http://texy.info/
[2]:http://texy.info/en/try/4q5we
--
Michal Čihař | http://cihar.com | http://blog.cihar.com
Quero sua opiniao leia tudo ta bjs!
--------------------------------------------
Olha isso!!_phpmyadmin-devel.zip: Nao Tem Virus!
Norton AntiVirus Procura Progressiva
Mais detalhes: www.symantec.com