|
|
 |
|
|
Thread Tools | Display Modes |
Apr 17th, 2005, 6:25 PM
|
#1 |
|
Newbie
Join Date: Apr 2005
Posts: 12
Rep Power: 0
 |
Database advice
After deciding Access is a pile of shit and cant handle any more than 5000 records without makin the comp run like a chimp with its balls nailed to the floor, ive come for some advice.
Id "like" to use an mysql database, but i really dont need anymore processes, nevermind anymore servers running off my comp, is there anyway to just make a database without having the server software installed? If not, then what else can i use? is xml worth it as a database? thanks, Illuminati. |
|
|
|
Apr 17th, 2005, 6:40 PM
|
#2 |
|
I eat cake for breakfast.
 
Join Date: Jul 2004
Location: In my box.
Posts: 4,434
Rep Power: 9
|
You could try XML, or even just a straight text file.
|
|
|
|
|
Apr 17th, 2005, 7:49 PM
|
#3 |
|
Newbie
Join Date: Apr 2005
Posts: 12
Rep Power: 0
|
im wondering whats going to be more efficient, the database is probably going to have around 8 to 10 thousand records added per week, dont think a text file would be able to handle that would it?
|
|
|
|
|
Apr 17th, 2005, 8:49 PM
|
#4 |
|
I eat cake for breakfast.
Join Date: Jul 2004
Location: In my box.
Posts: 4,434
Rep Power: 9
|
How about a text file for each day?
|
|
|
|
|
Apr 17th, 2005, 10:20 PM
|
#5 |
|
Newbie
Join Date: Apr 2005
Posts: 12
Rep Power: 0
|
na, that wouldnt do, needs to be one, maybe two files. needs to be easily searchable, so seperate days wouldnt work very well at all.
|
|
|
|
|
Apr 18th, 2005, 9:46 AM
|
#6 |
|
Programming Guru
Join Date: May 2004
Location: Brandon, Manitoba, Canada
Posts: 2,023
Rep Power: 7
  |
why not look into getting your db hosted on a server farm somewhere? That way you don't have to put anymore load on your boxes.
__________________
Profanity is the one language that all programmers understand. Check out my Blog <---updated Nov 30 2007! |
|
|
|
|
Apr 18th, 2005, 10:24 AM
|
#7 |
|
Programming Guru
Join Date: Aug 2004
Posts: 1,022
Rep Power: 6
 |
get a new server to run it you can get them for failry cheap. Esp if you build your own basic jobbie.
|
|
|
|
|
Apr 18th, 2005, 1:07 PM
|
#8 |
|
I eat cake for breakfast.
Join Date: Jul 2004
Location: In my box.
Posts: 4,434
Rep Power: 9
|
A database really is the best option.
|
|
|
|
|
Apr 18th, 2005, 2:16 PM
|
#9 |
|
Newbie
Join Date: Apr 2005
Posts: 12
Rep Power: 0
|
lol well yea it is the best option, but i didnt really want to be paying out anything as its more of a personal project.
|
|
|
|
|
| Bookmarks |
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
