Help with streamlining SQL queries


I have two pages (scripts) that need tightening up. My SQL is pretty basic.

First script is an address book. It has groups too. Currently 154 lines of code (including output code). I think I would like to put this in the session scope so when my user logs in their address book is created. If they add / edit / delete their address book it would need to be recreated. Pretty straight forward. I would like to try this myself and have whoever wins this bid help me get it right.

Next script is a summary panel. Currently 356 lines of code (including output code). The summary pulls data in from a few tables. As my SQL isn't so good I really need to make one big query instead of all these little ones. Again, I would like to have a bit of a go at this myself and get your help to get it the best it can be.

Thanks for your bids!

Taidot: Cold Fusion

Näytä lisää: streamlining sql queries, need sql help, i need help with my book, forward think, t-sql with, t-sql in, edit my book, think straight, t-sql;, sql, sql script , sql queries, sql data, Sql code, sql c, get sql help, C# SQL, best wins, sql created, fusion help

Tietoa työnantajasta:
( 78 arvostelua ) Kuranda, Australia

Projektin tunnus: #125697

Myönnetty käyttäjälle:


Look at PM

$70 USD 4 päivässä
(81 Arvostelua)

4 freelanceria on tarjonnut keskimäärin %project_bid_stats_avg_sub_26% %project_currencyDetails_sign_sub_27% tähän työhön


ready to help, i'm specialized in php & mysql

$30 USD 1 päivässä
(0 arvostelua)

See PMB for more information. Thanks.

$100 USD 6 päivässä
(0 arvostelua)

Hi, I've got a lot of experience in writing and optimizing queries. I've also got MySQL, MS SQL and ColdFusion MX7 servers running on my computer and ready to work for you.

$50 USD 2 päivässä
(0 arvostelua)