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.
Results 21 to 30 of 36
Thread: Merged: MySQL
-
10-09-2006, 03:52 PM #21C.I.A.
- Join Date
- Mar 2006
- Posts
- 2,935
Re: mySQL programming
-
10-09-2006, 05:44 PM #22Junior Member
- Join Date
- Oct 2006
- Gender
- Posts
- 38
Re: mySQL programming
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.
-
10-11-2006, 02:39 PM #23C.I.A.
- Join Date
- Mar 2006
- Posts
- 2,935
Re: mySQL programming
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.
-
10-11-2006, 02:42 PM #24C.I.A.
- Join Date
- Sep 2005
- Posts
- 2,773
Re: mySQL programming
dili diay ni kaya sa mysql?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.
-
10-12-2006, 12:49 PM #25Junior Member
- Join Date
- Oct 2006
- Gender
- Posts
- 38
Re: mySQL programming
mySQL can handle 1 million and higher records. some companies abroad, use mySQL as their database. naka RAC pa gani ang uban.
-
10-13-2006, 11:55 AM #26C.I.A.
- Join Date
- Mar 2006
- Posts
- 2,935
Re: mySQL programming
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?
-
10-13-2006, 05:09 PM #27 Re: mySQL programming
@spookey: You might want to use transactions in order to make atomic updates. =)
[ simon.cpu ]
-
10-14-2006, 06:58 PM #28Junior Member
- Join Date
- Oct 2006
- Gender
- Posts
- 38
Re: mySQL programming
@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.
-
10-16-2006, 12:47 PM #29C.I.A.
- Join Date
- Mar 2006
- Posts
- 2,935
Re: Merged: MySQL
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.
-
10-16-2006, 08:40 PM #30Site Keeper
- Join Date
- Sep 2003
- Posts
- 1,426
Re: Merged: MySQL
MS SQLServer on Mainframe? bro no offense but pwede diay MS SQLserver on a mainframe machines?
ALONE:Hated and Punished
Reply With Quote
Advertisement
Similar Threads |
|
Posting Permissions
|