Thinking about using an Access database to store a playlist (MP3 PLAYER)

[WarDemon666]

I dont care for regular playlist files, it will open the database, choose a playlist, and from there choose the song, which will have: Song name, song path, the song number, and maybe extra song info... Will it be slow to load it using a jet database with VB 6?

I was thinking:

Database --> Listbox

when the listbox is clicked, it loads it from the database..

and on start up of program, the database is loaded and fills the listbox with the song names...

What do you guys think??
Thanks

 

[jaybittle]

too many variables still outstanding.. total # of songs to be loaded?

there might be a maximum # of items in a list box, and if you have lots of songs (100,000 or more) you might crash the application, or use a lot of memory..

sounds like an interesting project, thou..

--jb

 

[WarDemon666]

Originally posted by: jaybittle
too many variables still outstanding.. total # of songs to be loaded?

What you mean? total songs could be loaded from the listbox later on... and I dont think a listbox has a max of 10 000, I mean, ive loaded more before ..probably

I probably wont ever have more than 10,000 songs...

 

[Confused]

Use an ADODB recordset instead, it a bit quicker than Jet.

A VB6 Listbox will hold 32,768 items (going from 0-32767). A ListView is only limited by available memory. I would use a ListView for future-proofing it.

That's what I'm doing with the VB6 application I'm writing for In-Car use - A.I.M.E.E


Garry

 

[WarDemon666]

Originally posted by: Confused
Use an ADODB recordset instead, it a bit quicker than Jet.

A VB6 Listbox will hold 32,768 items (going from 0-32767). A ListView is only limited by available memory. I would use a ListView for future-proofing it.

That's what I'm doing with the VB6 application I'm writing for In-Car use - A.I.M.E.E


Garry

You're the author of A.I.M.E.E?

theres so many frontends on mp3car.com, yet they are all missing something, and only one has the source code available (which doesnt work because I dont have mappoint installed.. ) so I have to code my own now!

Ive made quite a few mp3 players, but none of them were "touch screen compatible" so im going to have to code a new one...

Im just wondering if its worth the trouble...

Ive been coding for a day now, and its 1/20th's done IMO, yet there are front ends that took over a year to finalize.... dunno if I should do it or not...

 

[Confused]

Yeah, I am one of the authors of AIMEE I'm writing it with my friend, and we've got a couple more people working on extras.

I've been working on it since July last year...it's approaching Alpha release stage! Probably within the next few weeks! There are always things I'm adding/changing, so it always has more and more code!

What kind of things are "missing" from the others...? Maybe it's how it already works in AIMEE!


Garry