| Author |
 Topic  |
|
|
Nick Feakes
New Member
99 Posts |
 Posted - 06 January 2016 : 09:24:05
|
When using the search function the database sometimes gets stuck in a loop until the script times out. The database is not very large and it doesn't seem to matter what the search criteria are. I have created a log file and the script gets as far as creating the recordset on the line below "else 'end mySql specific code" (my line numbers are all off due to the log file entries).
This is the generated sql: SELECT DISTINCT C.CAT_STATUS, C.CAT_SUBSCRIPTION, C.CAT_NAME, C.CAT_ORDER, F.F_ORDER, F.FORUM_ID, F.F_SUBJECT, F.CAT_ID, F.F_SUBSCRIPTION, F.F_STATUS, T.TOPIC_ID, T.T_AUTHOR, T.T_SUBJECT, T.T_STATUS, T.T_LAST_POST, T.T_LAST_POST_AUTHOR, T.T_LAST_POST_REPLY_ID, T.T_REPLIES, T.T_UREPLIES, T.T_VIEW_COUNT, M.MEMBER_ID, M.M_NAME, MEMBERS_1.M_NAME AS LAST_POST_AUTHOR_NAME, F.F_PRIVATEFORUMS, F.F_PASSWORD_NEW
Sometimes the search works fine, today it locks up every time (the ldb file is generated). I did find a couple of errors in the database (F.T_REPLIES did not match the actual number of replies in FORUM_REPLY) which I have corrected.
All help / suggestions gratefully received.
Nick |
|
|
Nick Feakes
New Member
99 Posts |
Posted - 06 January 2016 : 10:59:45
|
Thank you for moving this, I did wonder if it was in the correct forum. However, I use an Access database not MySql (just to save any confusion). Perhaps I could trouble you to move it again?
Nick |
 |
|
|
HuwR
Forum Admin
United Kingdom
20584 Posts |
Posted - 06 January 2016 : 11:32:42
|
If your database is not huge you could try doing a compact/repair which may help, although you would probably need to download the database to do that.
The lockups may not even be a result of your database/search as it could be the server itself that is low on resources and therefore causing the issues.
Best advice would be to move to a more robust database backend rather than access. |
|
|
|
Nick Feakes
New Member
99 Posts |
Posted - 06 January 2016 : 15:10:31
|
Thank you Huw, I will get in contact with the server provider as I do not understand how a search can work perfectly one day, returning the result in under a second but lock up the system for several minutes another day with the same search word.
Is it possible to migrate the records to a different database?
Nick |
|
|
|
AnonJr
Moderator
United States
5768 Posts |
Posted - 06 January 2016 : 16:05:57
|
| It is possible to migrate from Access to MySQL or SQL Server. There are a few guides floating around here which I would recommend looking over as it's not quite a simple click-n-move type operation. |
|
|
|
Nick Feakes
New Member
99 Posts |
Posted - 06 January 2016 : 21:45:38
|
Thank you, I will search for a guide
Nick |
|
|
|
golfmann
Junior Member
United States
450 Posts |
|
| |
Topic |
|
