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 [EMAIL PROTECTED] -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Bozhidar Roydev Sent: Friday, September 27, 2002 3:14 AM To: [EMAIL PROTECTED] 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 ============================================================================
