On 3 Sep 2003 at 6:08, Azlin Ghazali wrote: > Hi, > > I'm working on a project to make an application run on MySQL and PostgreSQL. > I find that PostgreSQL runs up to 10 times slower than MySQL. For small records > it is not much problems. But as the records grew (up to 12,000 records) the > difference is quite significant. We are talking about 15s (MySQL) vs 111s > (PostgreSQL). Someone suggest that my way of implementing PostgreSQL is not > efficient and someone out there might be able to help. > > FYI, I running the application on ASP, XP Professional and Pentium 4 machine.
Are you running postgresql on windows? That's not an performance monster exactly? Is it under cygwin? BTW, did you do any performance tuning to postgresql? HTH Bye Shridhar -- Vulcans do not approve of violence. -- Spock, "Journey to Babel", stardate 3842.4 ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings