陷入困境的游戏公司 [英] A Game Company in Trouble
问题描述
我的名字是Nick Soutter，我是一家小型游戏公司的所有者，Aepox Games
（我们正在改名为Lamar Games），
www.lamargames.net 。
我们的第一款商业游戏Andromeda Online（ www.andromedaonline.net ）是
很快就会进入测试阶段。它运行在SQL Server 2000的评估版上
（我们的目的是，当它启动时，我们赚取钱来购买一份副本，然后评估到期。）
我们一直在测试Andromeda Online，并发现保存到数据库
需要大约10秒钟（我们预计不到1秒）。我们觉得我们需要
有人在优化sql数据库方面有经验帮助我们优化
数据库，并让它以我们特定的最佳方法运行$ / b
应用程序。
我们的程序用Java访问数据库，了解如何优化Java连接的人将会是一个巨大的帮助。
我的公司规模很小，老实说我们买不起。这个
项目的每个人，从声音家到图形艺术家，已经工作了1/10到
1/100的工作价值。我们只是一个寻找
专职人士的初创公司，他们愿意为信贷而不是金钱工作。
我们可以在我们的网站上提供信用卡
（ http://www.andromedaonline.net/credits .html ）给任何帮助我们的人，但
多一点（也许是100美元，但我们的预算非常多，而且迫切需要
of救命）。由于我们打算如何运行游戏（可能在线运行100-200
并发游戏），10秒的节省时间仅仅是不可接受的。
不可接受。
任何愿意帮助我们的人，请发简历到
他** @ andromedaonline.net 。经验会很好，但不是必需的。
我们正在寻找能够与我们的程序员讨论类型的问题的人
对我们的SQL数据库进行的调用，然后可以登录数据库并优化
它可以根据我们的特定需求尽快运行。
感谢您的时间。
Nick Soutter
Aepox（Lamar）游戏
My Name is Nick Soutter, I am the owner of a small game company, Aepox Games
(We''re in the middle of a name change from "Lamar Games"),
www.lamargames.net.
Our first commercial game, Andromeda Online (www.andromedaonline.net) is
going into beta soon. It runs on an evaluation edition of SQL Server 2000
(our intention is, when it launches, we earn the money to buy a copy before
the evaluation expires).
We have been testing Andromeda Online, and found that saves to the database
take about 10 seconds (we were anticipating less than 1). We felt we need
somebody experienced in optimizing sql databases to help us optimize the
database, and get it running in the best method for our particular
application.
Our program accesses the database in Java, and people with understanding in
how to optimize java connections would be a tremendous help.
My company is small, and we honestly cant afford much. Everybody on this
project, from the sound guys to the graphic artist, has worked for 1/10 to
1/100 of the value of the job. We''re simply a starting company looking for
dedicated people who are willing to work more for credit than money.
We can offer credit on our website
(http://www.andromedaonline.net/credits.html) to anybody who helps us, but
little more (maybe $100, but we''re very over budget, and in desperate need
of help). Because of how we intend the game to run (with maybe 100-200
concurrent games running online), a 10 second save time is simply
unacceptable.
Anybody who would be willing to help us, please send a resume to
he**@andromedaonline.net. Experience would be nice, but not a requirement.
We''re looking for someone who can talk with our programmer about the types
of calls made to our SQL database, and then can log into the DB and optimize
it to run as fast as possible considering our specific needs.
Thank you for your time.
Nick Soutter
Aepox (Lamar) Games
推荐答案
100 ，但我们非常超出预算，并迫切需要
的帮助）。由于我们打算如何运行游戏（可能在线运行100-200
并发游戏），10秒的节省时间仅仅是不可接受的。
不可接受。
任何愿意帮助我们的人，请发简历到
他** @ andromedaonline.net 。经验会很好，但不是必需的。
我们正在寻找能够与我们的程序员讨论类型的问题的人
对我们的SQL数据库进行的调用，然后可以登录数据库并优化
它可以根据我们的特定需求尽快运行。
感谢您的时间。
Nick Soutter
Aepox（Lamar）游戏
100, but we''re very over budget, and in desperate need
of help). Because of how we intend the game to run (with maybe 100-200
concurrent games running online), a 10 second save time is simply
unacceptable.
Anybody who would be willing to help us, please send a resume to
he**@andromedaonline.net. Experience would be nice, but not a requirement.
We''re looking for someone who can talk with our programmer about the types
of calls made to our SQL database, and then can log into the DB and optimize
it to run as fast as possible considering our specific needs.
Thank you for your time.
Nick Soutter
Aepox (Lamar) Games
BlackHawke写道：
BlackHawke wrote:
我们一直在测试Andromeda Online，并发现保存到数据库需要大约10秒钟（我们预计不到1秒）。我们觉得我们需要有一些优化sql数据库的经验来帮助我们优化数据库，并让它以我们特定应用程序的最佳方法运行。
我们的程序使用Java访问数据库，了解如何优化Java连接的人将是一个巨大的帮助。
一些简单的建议，对你的应用程序一无所知。
这个问题与你使用Java相关的可能性极小 -
基于数据库的接口。问题几乎可以肯定是你正在运行的SQL，并且与SQL向数据库本身发布数据的方式无关。但是，如果
你正在使用一些像OR映射器那样的高级抽象，那么一个例外就是适用的。
会为你生成SQL。这是手写的JDBC和SQL，还是
更复杂的东西？
任何愿意帮助我们的人，请发简历到
他** @ andromedaonline.net 。经验会很好，但不是必需的。
我们正在寻找能够与我们的程序员讨论对我们的SQL数据库进行调用的类型的人，然后可以登录到数据库和考虑到我们的特定需求，优化它以尽可能快地运行。
We have been testing Andromeda Online, and found that saves to the database
take about 10 seconds (we were anticipating less than 1). We felt we need
somebody experienced in optimizing sql databases to help us optimize the
database, and get it running in the best method for our particular
application.
Our program accesses the database in Java, and people with understanding in
how to optimize java connections would be a tremendous help.
Some simple advice, without knowing anything about your application.
It''s highly unlikely that the problem is related to your use of Java-
based interfaces to the database. The problem is almost certainly with
the SQL that you are running, and is independent of the means of issuing
that SQL to the database itself. An exception applies, though, if
you''re using some high-level abstraction like an OR mapper that
generates the SQL for you. Is this hand-written JDBC and SQL, or
something more complex?
Anybody who would be willing to help us, please send a resume to
he**@andromedaonline.net. Experience would be nice, but not a requirement.
We''re looking for someone who can talk with our programmer about the types
of calls made to our SQL database, and then can log into the DB and optimize
it to run as fast as possible considering our specific needs.
鉴于您的财务限制，对于
$可能更为谨慎b $ b你可以利用这个新闻组免费提供的建议。
你将被期望参与寻找解决方案，例如
put一起测试案例并进行一些故障排除，但如果你有一个关于事实或困难问题的真正问题，有人会很快就会跳出去帮助。
>
一个好的起点是查看
a中发布的语句。许多数据库都有一个可以捕获这些信息的日志记录模式，
但是如果你的数据库没有这样的模式或标志，你可以从应用程序中做到这一点
或者使用过滤器JDBC驱动程序。那么从
最简单的解决方案开始，您使用的是哪个数据库？
-
www.designacourse.com
培训任何人的最简单方法......无处不在。
Chris Smith - 首席软件开发人员/技术培训师
MindIQ Corporation
Given your financial constraints, it would perhaps be more prudent for
you to take advantage of the advice freely offered on this newsgroup.
You''d be expected to take part in finding the solution, by for example
putting together test cases and doing some troubleshooting, but if you
have a real question about a factual or difficult issue, someone will
almost certainly jump in to help.
A good place to start is to look over the statements that are issued in
a save. Many databases have a logging mode that can capture this info,
but if your database doesn''t have such a mode or flag, you could do it
from the application or with a filter JDBC driver. So to start with the
easiest solution, which database are you using?
--
www.designacourse.com
The Easiest Way to Train Anyone... Anywhere.
Chris Smith - Lead Software Developer/Technical Trainer
MindIQ Corporation
BlackHawke（bl ******* *@legacygames.net）写道：
BlackHawke (bl********@legacygames.net) writes:
我们的第一款商业游戏Andromeda Online（ www.andromedaonline.net ）即将进入测试阶段。它运行在SQL Server的评估版上2000年（我们的目的是，当它启动时，我们在评估到期之前赚取钱购买
副本）。
你什么时候下载这个评估版？请注意，原始的
评估版很容易受到Slammer蠕虫的攻击。如果你去
http://www.microsoft.com/sql你可以获得一个版本的评价
版本是Slammer-safe。
我们一直在测试Andromeda Online，并发现保存到
数据库需要大约10秒钟（我们预计不到1秒）。我们感觉我们需要有一些优化sql数据库的经验来帮助我们优化数据库，并让它以我们特定应用程序的最佳方法运行。
Our first commercial game, Andromeda Online (www.andromedaonline.net) is
going into beta soon. It runs on an evaluation edition of SQL Server
2000 (our intention is, when it launches, we earn the money to buy a
copy before the evaluation expires).
When did you download this evaluation edition? Beware that the original
evaluation edition is vulnerable for the Slammer worm. If you go to
http://www.microsoft.com/sql you can obtain a version of the Evaluation
Edition that is Slammer-safe.
We have been testing Andromeda Online, and found that saves to the
database take about 10 seconds (we were anticipating less than 1). We
felt we need somebody experienced in optimizing sql databases to help us
optimize the database, and get it running in the best method for our
particular application.
你究竟节省了什么？将单个
行保存到数据库需要10秒钟吗？或者整个游戏需要花费10秒钟来保存玩家的游戏吗？
后者可能意味着大量调用SQL Server来插入数据。
如果所有操作都是通过从Java
代码发送的INSERT语句，那么通过使用存储过程可以赢得很多。为了更高的速度，您可以构建一个XML文档，然后使用OPENXML（）在SQL Server端解压缩到
。你节省了很多网络往返
那样。
-
Erland Sommarskog，SQL Server MVP， so **** @ algonet.se
SQL Server SP3联机丛书
http://www.microsoft.com/sql/techinf .. .2000 / books.asp
这篇关于陷入困境的游戏公司的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
