Merged: MySQL

[spookey]

---

I think MySQL has no capability on Stored Procedure yet. Ipasend na lang og query imo front end to check for conflicts sa database nimo before saving.

[knight26]

mysql 5.0 and higher kay capable na mo handle ug stored procedure, functions, views and triggers. wla lang cyay jobs scheduler, sequence and many more.

[spookey]

how about relationships? naa na pud? maayo unta og naa kay magmigrate ko... medyo daku2x na raba amo data... makakaya kaha ni og 1 milyon+ records in 12 tables.

[Oakboy]

how about relationships? naa na pud? maayo unta og naa kay magmigrate ko... medyo daku2x na raba amo data... makakaya kaha ni og 1 milyon+ records in 12 tables.

dili diay ni kaya sa mysql?

[knight26]

mySQL can handle 1 million and higher records. some companies abroad, use mySQL as their database. naka RAC pa gani ang uban.

[spookey]

very good... now my only problem is how prevent a table from crashing due to blockouts. this usually happens when one or more of the 30 clients is updating the database when the blockout occurs. any idea guys?

[simoncpu]

@spookey: You might want to use transactions in order to make atomic updates. =)

[ simon.cpu ]

[knight26]

@spookey: is it real-time update gyud ba ang kinahanglan or pwede ra ug batch? if pwede ra ug batch, then why not try it.
if it is real-time, then you have to provide a UPS for your production server.

[spookey]

our company requires real-time. so i beleive we need to put a UPS on the machine. :mrgreen:

i hope i could migrate this to Microsoft SQL Server which is in our mainframe soon because it is very inconvenient for the end-users and developers.

[BadDudes]

MS SQLServer on Mainframe? bro no offense but pwede diay MS SQLserver on a mainframe machines?