4
Contributors
5
Replies
28
Views
2 Years
Discussion Span
Last Post by veedeoo
0

You can make user-defined function in SQL Server so it will speed up feching data from DB because server will do it faster then functions you create in programs.

0

@diafol It has lakes of records.

Edited by ashokkmr22: spell

0

@ashokkmr22

Is it twice or 4 times bigger than my database? Or, is it ten times bigger?

52ec7571e68051e6836fb4631c58c30d

I use MyISAM because I want a lock per session so that no other session can request while the current session hasn't finished. I prefer MyISAM in some project because of its speed and full text indexing. Otherwise, my first choice will be innoDB.

InnoDB is also good if you want to do transaction where several requests can be handled as one. You can either apply or revert on the InnoDB. InnoDB is capable of row locking and micro locking mechanism.

Innodb is being updated regularly while MyISAM is now almost to being neglected.

Edited by veedeoo: more info added

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.