Search:

Type: Posts; User: mujambee; Keyword(s):

Page 1 of 3 1 2 3

Search: Search took 0.05 seconds.

  1. Replies
    20
    Views
    4,436

    Re: Reboot Into... Windows [from Brainstorm]

    Case 1: My Windows takes ages to start and shutdown. I boot into it if I'll play a game, but if I want to google for something I boot Ubuntu which is much faster.

    Case 2: I've just compiled my...
  2. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    Bad, it looks bad. ;)

    It is a cross product of tables macnines, batches and shift, which will give you all possible combinations of the three. Have you checked your sums? I bet you get the same...
  3. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    I was thinking in SQL and only in SQL. As we have a Java client that can have some logic, there is a much better approach, using arrays to store temporary data. My idea is to have a local array of...
  4. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    Big queries get hard on your DB memory, not on your process. Your problem is that you are compositing that amount of data in place, try throwing it to a file as soon as you get it.
  5. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    From inner to outer:


    SELECT machine.name as machineName,
    orders.number as ordernumber,
    operator.id as operator ,
    0 as total
    FROM machine, orders,...
  6. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    version 1.1


    SELECT machineName, ordernumber, operator, Sum(total)
    FROM (
    SELECT machineName, ordernumber, operator, total
    FROM data_table
    UNION
    SELECT...
  7. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    Why not?



    SELECT machineName, order, operator, Sum(total)
    FROM table
    GROUP BY machineName, order, operator
    ORDER BY machineName, order, operator
    and get running.
  8. [ubuntu] My Transcend USB stick wont boot (and I'm sure I did it right)

    Hi all,

    I have a 2Gb LG USB Drive (http://www.lge.com/products/model/detail/ub2gvms01.jhtml) and a 8Gb Transcend JF V60 (http://www.transcend-uk.com/Products/ModDetail.asp?ModNo=126&LangNo=0)....
  9. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    Re reading gives me the impression that I didn't explain it right. What I don't like is the fact that your query is executed 2,247 times... That means going trough the preparation phase for that...
  10. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    That, in fact, is good news :D. I hope your customer understand the need for a really fast machine with huge ram and lightspeed hard drives.



    That's one of the many reasons that most DB's are...
  11. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    I don't like that. Try grouping your queries, and execute fewer queries that get more data each time. Bear in mind that executing a query goes trough a preparation phase prior to actually traversing...
  12. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    If they need reporting by the second then a summary won't help, but there might be a compromise:


    Define a minimum reporting timeslot: bigger timeslots allow for faster reporting; and add a...
  13. Replies
    5
    Views
    572

    Re: Where do I start with a complex project?

    Basic steps:


    Lay out your objectives. In this case, you should have a detailed set of features you want in your game, maybe two lists, MUSTs and COULDs.
    Design architecture. Define the basic...
  14. Replies
    3
    Views
    297

    Re: Learning resources for assembly?

    If you are going on Intel, go to http://www.intel.com/products/processor/manuals and read the whole of Volume 1.

    Then, if you feel that you need it, you can "start" learning assembler. ;)
  15. Replies
    29
    Views
    1,120

    Re: [SQL]Help me optimize

    If I read you right, you want report on material usage for every line, filtered by 5 fields.

    You can trade space for speed and have summary tables that store sumed up info: just add a table with...
  16. Re: FOSS IDE which can open MS Visual C projects?

    Visual Studio has an "Export makefile" option that should (or not) simplify the task. However, it's quite simple if you want to do it manually:

    The "project" is a .dsp file. It is a text file and...
  17. Re: Which is easier, Windows programming or Linux/Ubuntu

    Did I inadvertedly mention .NET? I seem to recall writing only about the Windows API ;)
  18. Re: Which is easier, Windows programming or Linux/Ubuntu

    That's one big point for Windows. There is a unified API that does ALL. If you don't know how to do this or that you can just go to MSDN and look it up. In a Linux system you first have to figure out...
  19. Replies
    48
    Views
    11,171

    Re: Best C/C++ Environment

    Definitely right for my Spanish programmers... :-D
  20. Replies
    48
    Views
    11,171

    Re: Best C/C++ Environment

    That's true, but if they get to the IDE they never learn anything else, they never do... :cry:
  21. Replies
    48
    Views
    11,171

    Re: Best C/C++ Environment

    Once you start doing things the easy way there is no coming back, you'll never learn the hard way unless hardly pressed. ;)
  22. Replies
    48
    Views
    11,171

    Re: Best C/C++ Environment

    Yes, it is, and I speak out of experience.

    At work we have to develop C and C++ servers, running on different Ux flavours. We have only telnet/FTP access, so no IDE for us. Many programmers...
  23. Replies
    6
    Views
    167

    Re: common spelling errors for bash commands

    What if I write a program and call it rysnc? :(
  24. Replies
    17
    Views
    1,000

    Re: A Tribute to Ubuntu's Stablility

    Ours was ;)
  25. Replies
    17
    Views
    1,000

    Re: A Tribute to Ubuntu's Stablility

    We used do that all the time at work, but the servers killed our processes when reached 4Gb or so (it's a 16Gb server). It was on Solaris.

    Finally we got rid of that programmer... :(
Results 1 to 25 of 58
Page 1 of 3 1 2 3