Contact US

Log In

Come Join Us!

Are you a
Computer / IT professional?
Join Tek-Tips Forums!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!

*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

Posting Guidelines

Promoting, selling, recruiting, coursework and thesis posting is forbidden.

Students Click Here

Working with large databases

Working with large databases

Working with large databases

I currently have a database that contains around 11 million records. If there is a power failure or if filemaker is shut down manually without closing the files, the large database is always damaged when I try and reopen it. Is there anyway for me to avoid this aside from creating backup copies? Also when a copy is made of the large database, is it normal for it to take 30-40 mins to back the file up? And indexing fields usually can take an hour to 8 hours depending on the field. The PC it is running on is new with a pretty good processor and 2 gb of memory. Would switching to FM server help in anyway? Or increasing memory/processor speed? Any advice would be great.

RE: Working with large databases

If you're running a database of that size you should really be using Filemaker Server.  You can program it to systematically backup the database at night.

Check you fields and make sure the ones that are indexed really need to be indexed; but yes, it will take that long to index them if they store a lot of data.

RE: Working with large databases

I agree with Cryogen.  All good suggestions.  You should also consider a UPS on database hosting machine as well.  II million records would be a lot to lose.


RE: Working with large databases

Thanks for the advice. What do u mean by "UPS"?

RE: Working with large databases

Uninterruptible Power Supply.  Basically, a big battery that automatically takes over if there is a power outage.  It plugs into the wall and your server plugs into it.

American Power Conversion Corporation is one of the leading manufacturers.


Red Flag This Post

Please let us know here why this post is inappropriate. Reasons such as off-topic, duplicates, flames, illegal, vulgar, or students posting their homework.

Red Flag Submitted

Thank you for helping keep Tek-Tips Forums free from inappropriate posts.
The Tek-Tips staff will check this out and take appropriate action.

Reply To This Thread

Posting in the Tek-Tips forums is a member-only feature.

Click Here to join Tek-Tips and talk with other members! Already a Member? Login

Close Box

Join Tek-Tips® Today!

Join your peers on the Internet's largest technical computer professional community.
It's easy to join and it's free.

Here's Why Members Love Tek-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close