Bill, I presently access MySQL on Linux and Sybase on Unix from MS Access on Win95 via ODBC links. I'm in the process of migrating the MySQL tables to PostgreSQL. Anecdotal, statistically unsubstantiated observations: Querying a few thousand rows takes no time at all; but scrolling through the result of a large select query seems to take longer than scrolling down the contents of a local table of the same size. 1. Was Sybase on the Win95 box, or were you accessing Sybase on a separate server? Was PostgreSQL and Kpsql on the same box? (I'm just trying to guage comparablility.) 2. Does performance diminish when you use Kpsql compared to using pgsql directly? 3. What other applications and services were turned on during your query? Which window manager do you use? - Andrew L. Gould Bill Barnes wrote:
SuSE 6.4, Postgresql 6.5.3 (out of the suse box), Using Kpsql. AMD-K6 2/400, 96mb, Samsung Ultra DMA drive, 208k swap space ATI XPERT 98 AGP, 8mb memory.
I just had my first fly at listing a Postgresql name file and it was depressing! The table was loaded using the copy command. the table has 14 columns, all varchar(<50). I selected all rows and fields, with 2 sort keys and it took *5.25* minutes to scroll all 2,673 rows through the results box of kpsql.
And when I tabbed through data in an adjacent help screen I could see an impact on the listing process.
On Windows 95 and Sybase this list was displayed virtually instantly.
What goes here?
Thanks for any relief of my trouble mind. Bill Barnes
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/
-- To unsubscribe send e-mail to suse-linux-e-unsubscribe@suse.com For additional commands send e-mail to suse-linux-e-help@suse.com Also check the FAQ at http://www.suse.com/Support/Doku/FAQ/