-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Friday 27 September 2002 03:14, Bozhidar Roydev wrote: > 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.
Kato razlika mezdu PostgreSQL i MySQL moze bi naj vaznite sa 2 : MySQL NE PODDURZA UNICODE/UTF-16/UTF-8, za razlika ot PostgreSQL i PostgreSQL poddurza trigeri i stored proceduri i njqkolko ezika za pisaneto im (vklucitelno i Perl), koeto ne e tochno taka v MySQL. Inache po skorostni pokazateli 2-ta SQL-a ne se razlichavat mnogo. > 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 > =========================================================================== >= - -- Dimitar Peikov Programmer Analyst Globalization Group "We Build e-Business" RILA Solutions 27 Building, Acad.G.Bonchev Str. 1113 Sofia, Bulgaria phone: (+359 2) 9797320 phone: (+359 2) 9797300 fax: (+359 2) 9733355 http://www.rila.com GnuPG key http://earth.rila.bg/~mitko/mitko.key.asc GnuPG key http://www.bgzone.com/~mitko/mitko.key.asc Key fingerprint 97AF 6192 78E2 AC68 FD56 CCB0 68B9 DF7D B3C1 9ED7 -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.0.6 (GNU/Linux) Comment: For info see http://www.gnupg.org iD8DBQE9ky9jaLnffbPBntcRAky8AKCFXg+PcEHWeRy77Bs8aXwxvtuc8gCgsLaS obfcTUGDuMB7kD3hOu5qVAo= =jvxo -----END PGP SIGNATURE----- ============================================================================ 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 ============================================================================
