corsasport.co.uk
 

Corsa Sport » Message Board » Off Day » Maths People - Predicting Data - Help ASAP!


New Topic

New Poll
  <<  1    2  >> Subscribe | Add to Favourites

You are not logged in and may not post or reply to messages. Please log in or create a new account or mail us about fixing an existing one - register@corsasport.co.uk

There are also many more features available when you are logged in such as private messages, buddy list, location services, post search and more.


Author Maths People - Predicting Data - Help ASAP!
James
Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline
20th Apr 07 at 00:02   View User's Profile U2U Member Reply With Quote

Basically, to cut a long story short, I wanted to put in a fancy equation to predict those results to show my lecturer that I've thought outside of the box a little bit

I know it isnt going to be particularly accurate, I just want an estimation based on the data that I have, is the method that Steve gave correct?

[Edited on 20-04-2007 by James]
Ian
Site Administrator

Avatar

Registered: 28th Aug 99
Location: Liverpool
User status: Offline
20th Apr 07 at 00:42   View Garage View User's Profile U2U Member Reply With Quote

Just do a line of best fit graph.

Excel calls them trend line.
Paul_J
Member

Registered: 6th Jun 02
Location: London
User status: Offline
20th Apr 07 at 09:55   View User's Profile U2U Member Reply With Quote

^^ so essentially your saying you want to fake results as your application was struggling to handle 50 users but you'd like to make it seem like it could handle 1000?
James
Member

Registered: 1st Jun 02
Location: Surrey
User status: Offline
20th Apr 07 at 10:01   View User's Profile U2U Member Reply With Quote

No I'm going to admit that I only tested it with 50 users, thats all part f my critical appraisal of the project, but then im going to go on and make some estimations
Paul_J
Member

Registered: 6th Jun 02
Location: London
User status: Offline
20th Apr 07 at 10:52   View User's Profile U2U Member Reply With Quote

plus (not knowing what you've made / testing) - surely say 1000 people are using it in real life, they wouldn't all be doing requests at the exact same point of time. I know myself with software calling upon databases, they do very quick queries or updates to the database and then cut the connection again. So the person may only be connected to the database for a split second. Thus the chance of say 100 users actually requesting from the DB all at the same point is nigh on impossible, most likely it'll be rare for even 2 to be doing the same at the same time.

The only thing I'd advise is making sure the application definately 'disposes' of the connection. One piece of software I wrote for my current company, I found that when I got up to about 10 + users, it started going slow / requests were taking a while etc. I couldn't understand it as I had written in my code for the program to close the connection after each action. However, unknown to me the software / database kept linked regardless. So by the time it got to 10 people or more there were 10 constant links into the database, causing lock issues and slowness.

I had to dispose the connections to sort it out. Could it be something like this which is causing errors at 50 users?

  <<  1    2  >>
New Topic

New Poll

Corsa Sport » Message Board » Off Day » Maths People - Predicting Data - Help ASAP! 24 database queries in 0.0081320 seconds