Hi all,
There are two problems, I am facing presently with my database.
1) For some of the tables, in the properties part page, it shows "overhead nnn bytes ". ( even if there are only 15- 20 records with record size of about 120 bytes). For this, if "optimize" option is selected, then the "overhead" is removed.
2) In some cases, while entereing the records through the form, records do not get saved. In few cases message shown is related to "unable to connect to localhost" or similar to database connection. In some cases, if the table list is seen, for one table or so, the message seen is "in use" instead of "number of rows, size of table " etc. In 2 - 3 occasions, the last entered records were deleted. (in one case 1 record was missing, in other case 4 records were lost)
In both above cases, independent table was affected. But how to track the lost record, if it has corresponding entry in other table / tables?
How to overcome these types of problems? Are there any utilities available, which can be used within the application, so that the client should not give frequent calls for these.
Is there any sort of list available, with common problems and there solutions?
