PDA

View Full Version : Is There A Limit To How Many Megabytes You Can Use In A Database??



Lanciferion
12-27-2013, 07:25 AM
I have recently gone on a major cd buying spree. I already have 3,455 cd's
in my database, with over 100 more on the way. I have noticed that the more
cd's I add, the longer it takes to load up. And now today, I had problems entering
the database. It kept freezing up, so I had to reboot my pc to get it to load again.
I just deleted a few cd's to make sure this doesn't happen again. I am up to 290.38
megabytes. So my question is, is there a limit, because it seems to me that I have
reached it. Is there anything I can do to continue on with this same database, or
will I need to start a new one. Like a part 2. I REALLY don't want to do this though.
Any help would be greatly appreciated. Thanks. Lance.

frederf
12-27-2013, 09:33 PM
Hmm... not sure why your database is so large..

this is may stats...
Size: 33.17 megabytes
Total records: 7030

Gagliem
12-27-2013, 10:24 PM
Frederf, yours is the typical size of the db,
maybe Lanciferion's database contains hi-scan artworks stored inside, instead of storing them in an external folder
(in this case, even if it has stored inside small jpg/gif pictures of almost 35kb each, if you multiply by 3.445 you'll reach easily 120mb only for storing pictures data...)

Lanciferion
12-27-2013, 10:33 PM
Yes. That is exactly why. My images are large
sometimes, and that is obviously becoming an
issue. I guess no one has a solution.

andrei_c
12-27-2013, 10:49 PM
Lanciferion,

Backup your database, then follow these steps:
http://www.firetongue.com/boards/showthread.php?t=6901#2

It will fix the performance issues.
Andrei

Lanciferion
12-27-2013, 11:28 PM
Thanks Andrei. I was hoping you would read this.
I didn't want to bother you with trivial stuff, but so
glad u popped in to help. I will try this when I get home.

Thanks again buddy!! U rule!!

Gagliem
12-28-2013, 07:19 PM
I see Andrei told you the solution, maybe I was cryptical when I said to store them in an external folder, what I meant is what Andrei showed in that thread.

Andrei, do you have news for us about the new db-engine you were working on ?

Cheers all
G.