#mysql - Fri 30 Mar 2007 between 07:33 and 08:53

NY Lost Funds



chad|afkarchivist is closer to the bot
Wh01swont happen again
chad get back to your paper
:P
chad|afkoh yea
Wh01shaha
your afk for a reason
chad|afkits not really true though... if i get afk i can't type my paper
its a catch 22
Wh01slol
afirc
:P
workingmani have a little problem : i use a mysql-client in server A and a mysql-server on server B. The first query i do takes 0.00sec and when i repeat it, it takes 0.21sec... what's happens ?
wh01s-think i just got pwnd
for talking in here
chad can you pm me your email the next time you see this
when i dissconnected it killed the window
going to blaze now bbl
lucifer4uarchivist, http://datamodel.org/NormalizationRules.html i have found that 5th normal form is the thing i was thinking about. and the number of links lay in range ( 0 ; (n-1)*(n+2)/2 ) for N entities. is it normal that in some situation i would have 5150 link tables for 101 entity ? would mysql work with such number of tables good?
archivist5k table does not sound a good idea
why not just rows in a link table
Melt_Downafaik mysql had an maximum table limit
and not a very high one
chad|afkplus mysql doesn't handle a ton of tables very well in my experience
although it may have been OpenBSD
M_AxL_MHi ! I need mysql for an app. There would probably be 1 000 000 rows per year in one table. Is mysql will support it or will it slow the app too much ?
Melt_Downthat depends greatly on the queries you do
archivistmillion rows should not be a problem
Melt_Down1M or 10M is no problem for mysql but it depends (like all db's) on you hardware (mostly mem) and the queries you do (use good indexes!)
M_AxL_MOk thanks :)
Qury will be sorted by date for instnce
lucifer4uarchivist, so is it good idea to have one table for all links something like id table_id_1 table_id_2 entity_id_1 entity_id_2 so it would link entity_id_1 from table table_id_1 to entity entity_id_2 in table_id_2 ?
M_AxL_MI guess it depends of hardware and type of query but what would be the time gap (middle value) ?
Less than 1 seconde ?
With recommanded hardware for example ..
Sealyis there any kind of function in mysql to return a ratio or like a percentage? say for example a simple count returns 50 out of 100 rows meet the condition of the select statement so it'll return 50%
workingmanproblem solved, my server MySQL had an MTU 8192 ans my client server had an MTU 1500 ...
Melt_DownSELECT SQL_CALC_FOUND_ROWS SELECT * FROM table WHERE a = 1 limit 0; SELECT COUNT(*)/FOUND_ROWS() * 100 FROM table
for sealy something like that
Sealyoh thanks Melt_Down

Page: 2 9 16 23 30 37 44 51 58 65 

IrcArchive

NY Lost Funds