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
I want to make a lyric database dedicated to a specific Genre. Now given the potential size of such a database of lyrics and the need for it to be searchable I want it to be as optomized as it can be. What would be the best means to store each lyric entry? flat-file with a database node containting artist-name, album, etc? I imagine this given my limited understanding of php would be the fastest method because it would reduce database size and I/O transfer speeds are faster than database calls? But then I'm adding both? am I not? And how would I minimalise search over-head? This as I imagine will be a large database having to scan all lyric entrys for lyric lines would be quite server intensive? and should I choose to go the flat-file route, will this require opening, scanning and closing over 100,000 files? Any guidance on this one would be greatly appreciated.
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