RE: lug-bg: PostgreSQL (MySQL) vs MSSQL

[larry@xxxxxxxxxxxxxxxxxxxx (Kostadin Karaivanov)]

Mhm ne sam guru po postgesql no w4era ili zaw4era gledah
testowe na zif davis m/du oracle9i i mysql s innoDB tables
razlika nqmashe .... da re4em 4e oracle beshe maaalko ama mnoo malko po-byrz
or mysqla
http://www.eweek.com/article2/0,3959,293,00.asp  twa e urlto s testa

pri mene obiknowen select ot tablica sys okolo 388 hilqdi reda minawa za
..... moment

mysql> select * from sofia where firstname='xxx';- malko konfidencialnost
:-))
nanan nananana
nanananana

1999 rows in set (3.40 sec)

mashinata e podobna kato hardware .....
i mislq 4e rezultata nikak ne e losh

Kostadin Karaivanov
Senior System Administrator @ Ministry Of Finance
tel: +359 2 98592062
larry@xxxxxxxxxxxxxxxxxxxx

-----Original Message-----
From: owner-lug-bg@xxxxxxxxxxxxxxxxxx
[mailto:owner-lug-bg@xxxxxxxxxxxxxxxxxx]On Behalf Of Bozhidar Roydev
Sent: Friday, September 27, 2002 3:14 AM
To: lug-bg@xxxxxxxxxxxxxxxxxx
Subject: lug-bg: PostgreSQL (MySQL) vs MSSQL

Zdrawejte kolegi,
Moi priqteli sa stignali do reshenieto da zamenqt MicroSoft SQL pod NT s
Linux baziran SQL server. Sega sa w sferata na experimentite i iskam da wi
pomolq za sydejstwie!
Otnachalo zapochnaha s MySQL, no sega sa prehwyrlili wsichko pod
PostgreSQL. Ponezhe ne sym se zanimawal s SQL-i shte predostawq
specializiranite wyprosi i otgowori na samite tqh. Predpolagam weche sa se
zapisali w grupata.
  Eto i nakratko configuraciqta i problema kakto sa mi gi izpratili:
                 configuraciq:
         Celeron 600 MHz
         Ram 128 MB
         Hdd 20 Gb
         OS RedHat 7.2
                 Problem:
Pri prosta zajawka ot 100 000 zapisa wremeto e 4sec
- natowarwane CPU 99%
Pri slojna zajawka - ot mnogo tablici i s uslowija
wremeto e 1 - 5 min w zawisimost ot zajawkata i
natowarwane na CPU 99 % za proces. Wsjaka zajawka si
owtarja proces. Pametta se zaema ne powece ot 3.5 % a
swap- a e prazen
Obsto wzeto w towa e problema - Za srawnenie systite
zajwki na MS SQL sa za okolo 1 sec.

Wyprosyt e dali e wyzmozhno optimizirane i kakwo mozhe da se ochakwa kato
max. byrzodejstwie?

-Bojo

============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================

============================================================================
A mail-list of Linux Users Group - Bulgaria (bulgarian linuxers).
http://www.linux-bulgaria.org - Hosted by Internet Group Ltd. - Stara Zagora
To unsubscribe: http://www.linux-bulgaria.org/public/mail_list.html
============================================================================