OZONE Asylum
Forums
Server-Side Scripting - Oh my!
Lyric Database - Design Considerations
This page's ID:
29066
Search
QuickChanges
Forums
FAQ
Archives
Register
Edit Post
Who can edit a post?
The poster and administrators may edit a post. The poster can only edit it for a short while after the initial post.
Your User Name:
Your Password:
Login Options:
Remember Me On This Computer
Your Text:
Insert Slimies »
Insert UBB Code »
Close
Last Tag
|
All Tags
UBB Help
[quote] [b]Trigger said:[/b] What would be the best means to store each lyric entry? flat-file with a database node containting artist-name, album, etc? [/quote] I would say database. A relational database structure would be much quick I would imagine rather than a bunch of files. [quote] [b]Trigger said:[/b] I/O transfer speeds are faster than database calls? [/quote] If I am guessing right, then no. I am imagining that the contents of all the lyrics are going to be quite large. Even with just one genre. Opening and closing every single file that contains lyrics is going to be a lot slower than querying a database. [quote] [b]Trigger said:[/b] should I choose to go the flat-file route, will this require opening, scanning and closing over 100,000 files? [/quote] pretty much. I would really look into a nice relational database design. keeping one table for the lyrics. Later, C:\
Loading...
Options:
Enable Slimies
Enable Linkwords
« Backwards
—
Onwards »
Maximum Security
OZONE
DHTML/Javascript
Server-Side Scripting - Oh my!
CSS - DOM - XHTML - XML - XSL - XSLT
Stupid Basic HTML
Visual Therapy
Photoshop
Photoshop Pong, Anyone?
***WARNING*** BIG SIG APPROACHING
Photography
3D Modelling & Rendering
Multimedia/Animation
Print Graphics
Holding Pens
Philosophy and other Silliness
Outpatient Counseling
Site reviews!
Mad Scientists' Laboratory
Getting to know the Grail