13-01-2008, 07:13 AM
what it really comes down to does the database support what you need
MySQL 5.X Supports Triggers and Functions but does have a few issues with the ADO currently. (Yes it works but advance stuff it will have issues with)
MySQL 4.1 does not support Triggers and Functions.
At work with out software we use SyBase which supports triggers and functions. And they really do help alot. You can use triggers to delete records or modify or update etc... records in another table when you do something with your current table. There are all sorts of things you can do to make things more effecient.
So figure out your needs and go from there.
MySQL 5.X Supports Triggers and Functions but does have a few issues with the ADO currently. (Yes it works but advance stuff it will have issues with)
MySQL 4.1 does not support Triggers and Functions.
At work with out software we use SyBase which supports triggers and functions. And they really do help alot. You can use triggers to delete records or modify or update etc... records in another table when you do something with your current table. There are all sorts of things you can do to make things more effecient.
So figure out your needs and go from there.