How to maintain a heavy weight data in the MYSQL DB?For Fetching a value takes more time.
ashokkmr22 0 Newbie Poster
Recommended Answers
Jump to PostCan you archive any records? What's your schema? How many records do you have in each table?
Jump to PostWell unless you provide more info, we can't really help that much
All 5 Replies
milil 24 Newbie Poster
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.
diafol
Can you archive any records? What's your schema? How many records do you have in each table?
ashokkmr22 0 Newbie Poster
@diafol It has lakes of records.
diafol
Well unless you provide more info, we can't really help that much
veedeoo 474 Junior Poster Featured Poster
@ashokkmr22
Is it twice or 4 times bigger than my database? Or, is it ten times bigger?
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.
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.