Programing help in SQL

[Xpage]

Does anybody have any idea what the fastest code "style" is for SQL. I know of CURSOR which si slow as hell and WHILE but are there any other methods. Thankfully I don't code but my friend does, so I'm trying to see if I can help him improve our game's code at all. Current our query run time is 20 minutes which is too long in my opinion though I will admit it does have to do alot in that one query.

 

[tkdkid]

Try adding an index. I would suggest keeping the query as simple as possible and putting the logic in code. Split it up into multiple queries if possible.

 

[KLin]

Post the query. I'm curious to see what a 20 minute query looks like.

 

[sourceninja]

I have a query that will take a hour or more to give results, if not timeout.

select * from tablename;

we have tables that will actually cause my machine to time out after giving a low virtual memory error. (Mostly only on finacial transaction tables)

To optimize sql you are going to have to look at some factors.

1) What database are you running? Are there any special features for said database you can use?
2) Can it be done with a stored procedure?
3) Can you optimize your index?
4) are you even using an index?
5) Could this be done using a view?
6) If this query is used a lot, is it being used consitantly (always written the same, caps, and all) and is it being cached?

Thats the crash course basics with looking at optimizing a sql query.

 

[Xpage]

Thanks for all the help. I'll see what I can get to post here for you guys to critique. Sadly I'm the game deisgner but not the code designer or coder, so my knowledge in this area is very tiny, thus my psot for your help. I am sure my coder hasn't thought of everything and any optimization is a good one. stay tuned for more information