I have had my forums running for about a year now.

http://www.cubafar.com/forum/ - http://www.cubafar.com/forum/

Last week I had to download the DB locally and compact and fixed with access because It was so slow that I got script time out.

I did try to migrate to 7.0 but when I did the database migration the new forum didn’t show any of the static and what was worst it had some crash when I try to insert new post. A reference problem I guess. Any way the migration couldn’t happen.

Now I’m still running 6.34 and I’m not getting script time out after I did compact the DB but is still very slow. Anybody could help me to fix this problem?

Thanks in advance.

No, it does not look like a large Access DB problem - Judging by the number of Threads, Posts and Members it is several times smaller than mine which runs perfectly well at a shade over 10Mb. To me, it looks like a server problem (since the site itself is slow to load) that may just require a simple reboot so have a word with your Host.

Concerning the migration, you MUST perform a compact/repair on the old 6.34 AND the empty new v7 BEFORE running the migrator. After migration perform another compact/repair on the newly populated v7 DB. The stats will require resychronising which Borg has provided using the Admin facility once installed.

Please repair and compact your data base. If you want to upgrade to 7.1 do the same befor conversion and after.

You can find the "Re-sync Topic and Post Count" function in the administration page.

Good luck!

As I said, not on my site - No crashes whatsoever and still as fast as ever, with regular compaction of course. If the design is good and the DB properly maintained, there is no reason why it should suddenly fail above 7MB. Proof is mine hasn't.

I have an access database running the version 7 of the forum and never have any trouble with it, not even speed issues.

What size is the database I hear you ask?

89.2mb!

Never been compacted other than the switch from 6.4

Bliss wrote: 10 mb is considered large for access. Access can be depended on until it reaches about 7 mb, and then it gets unreliable, and gets slow or crashes a lot.

Where in the world do people get these numbers from!

The size you can run an access database depends on a number of things.

As Access was not designed to be a web backend database system and as it is a flat file database the performance of it when used for web applications is not great.

If you are on your own dedicated server with no other sites on the server and a powerful server than you can have quite large access databases.

If you are on a shared server than depending on the power, memery available and the number of sites on the server 10mb can be considered very large, as each time someone connects to the forum the whole 10mb file needs to be loaded into memory. If the server is busy, or if someone on the server is using bad programming and has eaten up allot of the server memory then the forum with an access database will run slow and give timeout errors as it takes quite allot of server resources to open an access database using the JET database drivers form an asp application.

If you find that your forum runs slow with access then you have two choices, get a dedicated server, or switch to SQL server. I would go for the SQL srever as it is much cheaper.

I'm using Access version and the database is 7.5MB now. Though the forum is runing well till now, I'm thinking about tranfer it to the SQL version.

Can you tell me where can I get the tool for migration? I searched on this web site but no luck.

Thanks!

There is no migration tool, but you can use the upsize wizard in Access to upsize your database to SQL server, then run the SQL server serup file found in the SQL server version to create the stored procedures.

You will get a few errors come up when running this file as most of the tables will be cerated by the upsize process, but just ingnore these.

Also you may find that extra admin and guest accounts and groups are cerated that you will need to delete from the admin area.