I feel for ya man, luckily I'm on spring break right now. My advice for you is: do not give up on your RPG. First, make smaller programs that have functions that will help you in building your RPG. For example make a program called DUEL, where two dudes duke it out Final Fantasy turn-based style. Have another one where you walk around on a world map then when you get to a town tile you get to go inside and talk to people.
The DB sprite commands are indeed a little slow. There are two main solutions to this problem, there are others, but these are the most obvious.
1. Upgrade your computer. May be expensive, and being in school doesn't help, I know. But your system specs scare me.
2. Use 2d3d. Meaning, instead of using LOAD IMAGE, SPRITE, etc. make a bunch of 3d plains and texture them with your images. Then you can have the texture scroll to simulate the animation effect. Imagine a roll of film running through a light projector thing. The projector sees one piece of film at a time but if you scroll it fast enough it looks like a moving image.
Keep posting, we'll help you.
The Bear
P.S. You're only a failure if you admit to it. My FPS demo right now has a bug in the collision: but it is
not a failure. You are having trouble with the slow 2d commands, but you are
not a failure.
Crazy Donut Productions
Current Project: KillZone