Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations wOOdy-Soft on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by OldProgrammer

  1. OldProgrammer

    My C-program inserts into mySql slowly if run remotely

    If exactly the same compile image works differently on two different databases - maybe you need to look elsewhere? I'd suggest looking at show variables - this might highlight some setting differences or some value differences - switch slow query loggin on using mysql.cnf - this might highlight...
  2. OldProgrammer

    Need Urgent advice to a structured db

    You might want to consider the following - if you hold a user id in designer table and your designs are keyed unique on designer_id + design_id then you can select * from designs d, designer a where a.designer_id=d.designer_id and a.user_id =$USER_ID This would restrict the designer to his...
  3. OldProgrammer

    Filtering the results of one query for another

    if I've got the requirement correct What about: SELECT * FROM chanlist WHERE channame NOT IN (SELECT channame FROM suspend) ?
  4. OldProgrammer

    Performance problems with basic queries:

    Hopefully someone can suggest something: I've got a default MySQL installation running on Linux. Single table queries access acceptably (normally sub second) however when I do a simple 2 query table I get ridiculous results Table a - 30,000 rows - (approx 100bytes) Table b - 460,000 rows -...
  5. OldProgrammer

    Join problem

    If I understand you correctly you simply need to add the function MAX()to your query: Select t.id, t.title, max(v.value), max(v.hour) from titles t, values v where v.id_title=t.id and t.index='abc' group by t.id, title Hope this helps?
See more

Part and Inventory Search

Back
Top