Recently, I try to introduce my friend to use PostgreSQL.
However, he first impression is that. PostgreSQL is much slower compared to MySQL. He realize he has to wait for 7 seconds, to create a tmp database.
He run a command through pgadmin GUI.
"CREATE DATABASE TMP;"
I try to run through command prompt instead. It tooks 2 seconds.
May I know what is the reason, SQL query execution is *much* slower in GUI PgAdmin?
Thanks and Regards
Yan Cheng CHEOK