Welcome to the GoFuckYourself.com - Adult Webmaster Forum forums.

You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. Registration is fast, simple and absolutely free so please, join our community today!

If you have any problems with the registration process or your account login, please contact us.

Post New Thread Reply

Register GFY Rules Calendar
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >
Discuss what's fucking going on, and which programs are best and worst. One-time "program" announcements from "established" webmasters are allowed.

 
Thread Tools
Old 09-19-2003, 07:07 AM   #1
Andy
Confirmed User
 
Join Date: Jan 2001
Location: A nice little folder on some C drive inside a huge server ;)
Posts: 460
how fast is MySQL ??

hey guys,
just wondering how fast is MySQL ... I've mainly used file system and not database so I'd like to know which one is faster and uses lower server resources... thanks
__________________
Submit Your Movie Galleries Trade Movie Traffic: 43559081
Andy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 09-19-2003, 07:09 AM   #2
txtbill
Confirmed User
 
Join Date: Sep 2003
Location: Bradford - UK
Posts: 341
Im not an expert on this but mysql can easily handle anything that the standard webmaster needs.

If you need a more robust database with aditional features I would suggest Postgresql other wise mysql will do the job.

Aaron Mc
__________________
SIG TOO BIG! Maximum 120x60 button and no more than 3 text lines of DEFAULT SIZE and COLOR. Unless your sig is for a GFY top banner sponsor, then you may use a 624x80 instead of a 120x60.
txtbill is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 09-19-2003, 07:10 AM   #3
Jimbo
Confirmed User
 
Industry Role:
Join Date: Oct 2001
Location: Montreal
Posts: 3,989
how fast is your server ?
__________________
free sex videos
Jimbo is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 09-19-2003, 07:12 AM   #4
Libertine
sex dwarf
 
Libertine's Avatar
 
Join Date: May 2002
Posts: 17,860
As far as databases go, MySQL is one of the fastest. Most definitely not one of the most stable databases, and it lacks quite a few more advanced options, but it is fast.

Whether you need a database or not depends on what you want to do though. Can't really say anything about that without knowing what it is you want to do.
__________________
/(bb|[^b]{2})/
Libertine is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 09-19-2003, 07:13 AM   #5
Andy
Confirmed User
 
Join Date: Jan 2001
Location: A nice little folder on some C drive inside a huge server ;)
Posts: 460
i'd like to know if it's fater then filesystem ... does the server metter ?
__________________
Submit Your Movie Galleries Trade Movie Traffic: 43559081
Andy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 09-19-2003, 07:20 AM   #6
Libertine
sex dwarf
 
Libertine's Avatar
 
Join Date: May 2002
Posts: 17,860
Quote:
Originally posted by Andy
i'd like to know if it's fater then filesystem ... does the server metter ?
Like I already said, it depends on what you want to do. Do you want to retrieve single entries by id? Or do you want to search for specific entries?
__________________
/(bb|[^b]{2})/
Libertine is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 09-19-2003, 07:21 AM   #7
Libertine
sex dwarf
 
Libertine's Avatar
 
Join Date: May 2002
Posts: 17,860
And here's a link that might be helpful:
http://revjim.net/comments/9489/
__________________
/(bb|[^b]{2})/
Libertine is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 09-19-2003, 07:51 AM   #8
Arty
Confirmed User
 
Join Date: Nov 2002
Posts: 880
Quote:
Originally posted by Andy
i'd like to know if it's fater then filesystem ... does the server metter ?
If you are holding a big database, querying that using indexes with MySQL would be faster. But if it's something small, filesystem might be better ..

As punkworld said, that depends on many factors. Size of your data, speed of your system, HDD type, etc.
Arty is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Old 09-19-2003, 08:02 AM   #9
Andy
Confirmed User
 
Join Date: Jan 2001
Location: A nice little folder on some C drive inside a huge server ;)
Posts: 460
Quote:
Originally posted by punkworld
And here's a link that might be helpful:
http://revjim.net/comments/9489/
nice link .. thanks guys I already know what I wanted to know ..
__________________
Submit Your Movie Galleries Trade Movie Traffic: 43559081
Andy is offline   Share thread on Digg Share thread on Twitter Share thread on Reddit Share thread on Facebook Reply With Quote
Post New Thread Reply
Go Back   GoFuckYourself.com - Adult Webmaster Forum > >

Bookmarks



Advertising inquiries - marketing at gfy dot com

Contact Admin - Advertise - GFY Rules - Top

©2000-, AI Media Network Inc



Powered by vBulletin
Copyright © 2000- Jelsoft Enterprises Limited.