ORACLE se RH6.0

[Alexander Papadakis]

>
> Exume ena table me 45.000.000 records.
> I select mas epistrefei ta data apo 0.0 secs mexri 0.5secs. Dokimase to
auto sti PosgtGress. Episis, h mySQL exei ena paly kalo query optimizer ( pu
merikes fores paraeinai kalos ).
>
> Mark
>

Marko, Marko!, Marko?

Koimasai kala ta bradia???
(Egw sth thesh sou tha eblepa 45ek. records na bouliazoun
 sto /dev/null..)


Tha sou proteina na katebaseis thn Sybase 11.9 gia Linux.

Balthn se ena SMP mhxamhma, me osous epegergastes antexei
h tseph sou.

Ftiaje ta tables sou, xwrismena se polla segments.

Ftiaje ta indexes sou analoga me to queries pou kaneis.

Katebase ta free tools pou dinei h Sybase gia administration/dev
apo Windows (Sybase Central,Modeler!!!,Info maker..)

Setarise th mnhmh sou (Dwse sth database 30-500M)
Ftiaje tis (data)caches sou..
Setarise tous epejergstes pou theleis na kanei utilize.
Setarise to parallhlo processing...

Sthse to Monitor server sou (optional)
Sthse to Backup server sou (optional)
Bale mesa ta dedomena sou.

Kane merika arxika queries kai des taxythta...

Ayrio pou tha theleis kai deytero,trito,tetarto mhxanhma
tha baleis kai ena replication kai eisai Ok!

Methavrio pou tha katebaseis thn 12, tha mporeis na grafeis
ths stored procedures sou se Java (kai oxi mono...)


TO MONO tradeoff pou tha exeis einai to kostos tou
connection... Alla an eisai magkas (poly magkas omws),
mporeis na xtiseis panw ston OpenServer pou dinei to
diko sou http server...


An kapote h sybase apofasize na dwsei :
 -unix sockets
 -stored functions
 -mikrotera kai periektikotera manuals.. ;-(
tha tous patouse olous katw..

Mia kalh seira pantws epiloghs bashs (IMHO), analoga me
thn efarmogh pou theleis na sthseis se linux einai:

Sybase/Oracle (SMP)
Solid SynchroNet (SMP)
PostgreSQL (??)
Mysql/msql
loipes..

To kalytero einai pantws na syndiaseis oses apo tis
parapanw mporeis: Sybase san master/sec storage, Mysql gia
local cache ktlp ktlp..


Kai liga apo thn proswpikh mou empeiria me thn mysql..

Kalh, de lew. Anti na kathesai kai
na ftiaxneis perierga hash tables,dentra, ktlp ktlp,
se opoia glwssa protimas, bazeis mia MySql kai kaneis
th douleia sou... Exeis kai source opote...

Ta udf pou exei mallon ta trexei seiriaka se sygkekrimeno
context me locks.   (An kapoios exei asxolhthei me udf
kai nomizei to antitheto, please as mou steilei mail,
giati me "kaiei" to thema...)

To ypothpwdes recovery-replication pou exei einai
aparadekto. Des taxythta sta insert sou me energopoihmeno
log! Kollaei olh h bash otan baleis merikes xiliades
rows mesa!! (An kanenas endiaferetai gia ena mikro
GPL projectaki gia pio sobaro replication sthn Mysql,
as mou steilei mail na tou pw tis idees mou pou den
exw xrono na dokimasw... Marko??)

Den einai SMP

Oso gia thn ajiopistia ths:
Content-type: text/html Pragma: no-cache Error : 1115
You have an error in your SQL syntax near 'etitle like '%EVER%' AND edes
like '%EVER%' AND etitle like '%MYSQL%' AND edes l' at line 1

Ti epathe o Optimizer? Den antexei megala queries??


Kai gia na mhn parejhghthw, proswpika den eimai
eyxarisitmenos apo thn Sybase... Apla mou dinei
th dynatothta na perasw to business logic twn
efarmogwn sth idia th bash, einai grhgorh, kai
propantwn safe...



Arketa! oxi allh xolh shmera.


alpapad

PS: marko xairetismata se olh thn parea ekei katw..

PPS: Yparxoun ellhnika Locales gia thn sybase alla
     mallon den symperiferontai kai para poly kala,
     oso afora tous clients se Windows...



>
> Giorgos Keramidas wrote:
> >"Mark Papadakis" <markp at pathfinder.gr> writes:
> >
> >> H mySQL einai kata poly grigoroteri ( the fastest RDBMS ever )
> >kai
> >> exei para polles dinatotites. At least gia Web Development.
> >> subselects, transactions, views kai stored procedures einai sta
> >TODO (
> >> lene se 4 mines na einai ola auta etoima ) alla einai para poly
> >kalh.
> >>
> >> Exei cli based tools kathws kai polla alla gia X/Win.  O
> >Pathfinder
> >> stirizetai 100% se mySQL kai den mas exei dimiourgisei kanena
> >> problima. An thelete taxitita kai robustness, its the way to go.
> >>
> >> Mark
> >
> >Twra dev 8elw va tsimpnsw, alla oi kakes oi glwsses, autes av0rwpwv
> >pou
> >paizouv kai me MySQL kai me PostgreSQL tautoxrova, mazi kai me tnv
> >dikn
> >mou tnv uperkakn glwssa, leve ... pws n MySQL kavei kati ligotero apo
> >to
> >diplasio xrovo apo autov pou 8elei mia PgSQL va sou kavei SELECT se
> >eva
> >table me kamposes xiliades eggrafes (sinithos > 100,000).  Kai
> >epeidn
> >eivai teleiws xazoi autoi pou tin ftiaxnoune, exei nested SELECTs,
> >exei
> >triggers, exei eswteriko query optimizer pou kanei ta nested select
> >tns
> >va trexouv polu pio grngora apo ta avtistoixa N select pou 8eleis se
> >MySQL gia va mimn8eis to SELECT kati FROM (SELECT allo FROM ...).
> >
> >Alla... uparxei ena alla omws.  Opoios 8elei rollback, den tin
> >sinistw.
> >Epishs, den exei ton idio ari8mo apo ergaleia diaxeirisis pou exei
> >mia
> >MySQL, oute se X11, oute mesa apo Web.  Ki o,ti kai na leme, to
> >MySQLadmin se PHP einai mia porosi.
> >
> >Sumperasma?
> >Mpa... bgalte o kathenas monos tou.
> >
> >--
> >Giorgos Keramidas, <keramida at ceid.upatras.gr>
> >"What we have to learn to do, we learn by doing."
> >[Aristotle]
> >--
> >====================================================================
> >Gia boithia (h na diagrafhte) e-mail sto majordomo at hellug.gr
> >Ta archives tis listas einai sto http://lists.hellug.gr/archives
> >prin steilete kapoia erothsh psakte mipos exei hdh apanththei.
> >Gia opoiodipote problima stilte e-mail ston
> >owner-linux-greek-users at hellug.gr
> >====================================================================
>
> --
> ====================================================================
> Gia boithia (h na diagrafhte) e-mail sto majordomo at hellug.gr
> Ta archives tis listas einai sto http://lists.hellug.gr/archives
> prin steilete kapoia erothsh psakte mipos exei hdh apanththei.
> Gia opoiodipote problima stilte e-mail ston
owner-linux-greek-users at hellug.gr
> ====================================================================

--
====================================================================
Gia boithia (h na diagrafhte) e-mail sto majordomo at hellug.gr
Ta archives tis listas einai sto http://lists.hellug.gr/archives
prin steilete kapoia erothsh psakte mipos exei hdh apanththei.
Gia opoiodipote problima stilte e-mail ston owner-linux-greek-users at hellug.gr
====================================================================