Re: [WebDNA] Not even sure what to ask for help on. . . :(
This WebDNA talk-list message is from 2008
It keeps the original formatting.
numero = 101634
interpreted = N
texte = Sounds more like a bandwidth problem then a WebDNA problem.... What kind of line is this on?RobOn 15-Dec-08, at 2:59 PM, David Bastedo wrote:> Ok, so I just did a soft launch of a site on Friday and my site> traffic jumped over 200%. Normally, that would be great, except the> site has now slowed to a crawl.>> I have many images on a seperate server, I have just added 6gb to the> server - emrgency like, hoping it will help - it has - marginally -> and now I am in the process of adding a third server - I also have one> for streaming - and am planning on moving everything to MySQL - I> think - though it would not be my preference.>> Anyway before I can even contemplate that - doing that will take a> fair bit of time - I need to get the current site as fast as possible,> to buy me some time to do this new update.>> I guess my biggest question is on tables. I am using tables on this> site and I think that this may be the biggest issue. I need to do a> lot of sorting and it "seemed" like the best, most convinient way to> do it, though now I am wondering if this has caused way more problems> that it has solved.>> Is it better to write to a temp db and then sort those results, if I> have to, rather than a table:>> Here is a sample piece of code. (I am making custom music playlists > BTW)>> [table > name=MyPlayListData&fields=PlayListItemID,PlayListID,Sequence,ConcertID,FLV_FileName,UserID,DateCreated,LastUpdate,FLV_Length,PlayListName,PlayListDescription,AlbumID,HSPSongID,PlayListID,PlayListDescription,UserID,PlayListType,DateCreated,timeTotal,MySongName,AlbumName,releaseDate,rating,MyRating][/table]>>> [Search db=[pagePath]databases/ > aaa > .db > &gePlayListIDdata > = > 0 > &eqAlbumIDdata > =303&albumIDtype=num&[SO]sort=1&[SO]dir=[SB]&[SO]Type=num]> [founditems]> [replace > table > = > MyPlayListData > &eqPlayListIDdatarq > = > [PlayListID > ]&PlayListIDtype > = > num > &eqUserIDdatarq > =[UserID]&UserIDtype=num&eqHSPSongIDdatarq=[HSPSongID]&append=T][!]> [/!]PlayListItemID=[PlayListItemID][!]> [/!]&PlayListID=[PlayListID][!]> [/!]&Sequence=[Sequence][!]> [/!]&ConcertID=[ConcertID][!]> [/!]&FLV_FileName=[FLV_FileName][!]> [/!]&UserID=[UserID][!]> [/!]&DateCreated=[DateCreated][!]> [/!]&LastUpdate=[LastUpdate][!]> [/!]&FLV_Length=[FLV_Length][!]> [/!]&PlayListName=[PlayListName][!]> [/!]&PlayListDescription=[PlayListDescription][!]> [/!]&AlbumID=[LOOKUP> db=[pagePath]databases/ > yyy.db&value=[PlayListID]&lookInField=PlayListID&returnField=AlbumID] > [!]> [/!]&HSPSongID=[HSPSongID][!]> [/!]&PlayListName=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value=[PlayListID]&lookInField=PlayListID&returnField=PlayListName] > [!]> [/!]&PlayListDescription=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value > =[PlayListID]&lookInField=PlayListID&returnField=PlayListDescription] > [!]> [/!]&UserID=[LOOKUP> db=[pagePath]databases/ > yyy.db&value=[PlayListID]&lookInField=PlayListID&returnField=UserID] > [!]> [/!]&PlayListType=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value=[PlayListID]&lookInField=PlayListID&returnField=PlayListType] > [!]> [/!]&DateCreated=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value=[PlayListID]&lookInField=PlayListID&returnField=DateCreated][!]> [/!]&rating=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value > = > [PlayListID > ]&lookInField=PlayListID&returnField=rating]&MyRating=[search> db=[pagePath]databases/ > xxx.db&eqStoryIDdatarq=[PlayListID]&eqUserIDdatarq=[GETCOOKIE> name=xxx]][founditems][TheRating][/founditems][/search][/replace]>> [/founditems]> [/search]>> -> then I have to do two more seraches. One for the results and one> for next/prev>> [search > table > = > MyPlayListData > &gePlayListIDData > = > 0 > &eqalbumIDdatarq > = > 303 > &PlayListIDsumm > = > T > &[SB]sort=1&[SB]sdir=[SO]&[SB]type=[SB_type]&startAt=[startat]&max=10]>>> I know I can make this code more streamlined, but I am not sure if it> is the tables that are a problem.>> Without a load, these pages work great, but with the increased> traffic, it now takes - well WAY too long to load a page. Anyway, I am> going through and make my code thinner, as it were - I can get rid of> a bunch of the lookups above and replace with another search, but I am> wondering if I should replace all the tables in the site with a temp> .db.>> Any thoughts? or advice? Thanks in advance.>> D.>>> -- > David Bastedo> Ten Plus One Communications Inc.> http://www.10plus1.com> 416.603.2223 ext.1> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list
.> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> old archives: http://dev.webdna.us/TalkListArchive/
Associated Messages, from the most recent to the oldest:
Sounds more like a bandwidth problem then a WebDNA problem.... What kind of line is this on?RobOn 15-Dec-08, at 2:59 PM, David Bastedo wrote:> Ok, so I just did a soft launch of a site on Friday and my site> traffic jumped over 200%. Normally, that would be great, except the> site has now slowed to a crawl.>> I have many images on a seperate server, I have just added 6gb to the> server - emrgency like, hoping it will help - it has - marginally -> and now I am in the process of adding a third server - I also have one> for streaming - and am planning on moving everything to MySQL - I> think - though it would not be my preference.>> Anyway before I can even contemplate that - doing that will take a> fair bit of time - I need to get the current site as fast as possible,> to buy me some time to do this new update.>> I guess my biggest question is on tables. I am using tables on this> site and I think that this may be the biggest issue. I need to do a> lot of sorting and it "seemed" like the best, most convinient way to> do it, though now I am wondering if this has caused way more problems> that it has solved.>> Is it better to write to a temp db and then sort those results, if I> have to, rather than a table:>> Here is a sample piece of code. (I am making custom music playlists > BTW)>> [table > name=MyPlayListData&fields=PlayListItemID,PlayListID,Sequence,ConcertID,FLV_FileName,UserID,DateCreated,LastUpdate,FLV_Length,PlayListName,PlayListDescription,AlbumID,HSPSongID,PlayListID,PlayListDescription,UserID,PlayListType,DateCreated,timeTotal,MySongName,AlbumName,releaseDate,rating,MyRating][/table]>>> [Search db=[pagePath]databases/ > aaa > .db > &gePlayListIDdata > = > 0 > &eqAlbumIDdata > =303&albumIDtype=num&[SO]sort=1&[SO]dir=[SB]&[SO]Type=num]> [founditems]> [replace > table > = > MyPlayListData > &eqPlayListIDdatarq > = > [PlayListID > ]&PlayListIDtype > = > num > &eqUserIDdatarq > =[UserID]&UserIDtype=num&eqHSPSongIDdatarq=[HSPSongID]&append=T][!]> [/!]PlayListItemID=[PlayListItemID][!]> [/!]&PlayListID=[PlayListID][!]> [/!]&Sequence=[Sequence][!]> [/!]&ConcertID=[ConcertID][!]> [/!]&FLV_FileName=[FLV_FileName][!]> [/!]&UserID=[UserID][!]> [/!]&DateCreated=[DateCreated][!]> [/!]&LastUpdate=[LastUpdate][!]> [/!]&FLV_Length=[FLV_Length][!]> [/!]&PlayListName=[PlayListName][!]> [/!]&PlayListDescription=[PlayListDescription][!]> [/!]&AlbumID=[LOOKUP> db=[pagePath]databases/ > yyy.db&value=[PlayListID]&lookInField=PlayListID&returnField=AlbumID] > [!]> [/!]&HSPSongID=[HSPSongID][!]> [/!]&PlayListName=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value=[PlayListID]&lookInField=PlayListID&returnField=PlayListName] > [!]> [/!]&PlayListDescription=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value > =[PlayListID]&lookInField=PlayListID&returnField=PlayListDescription] > [!]> [/!]&UserID=[LOOKUP> db=[pagePath]databases/ > yyy.db&value=[PlayListID]&lookInField=PlayListID&returnField=UserID] > [!]> [/!]&PlayListType=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value=[PlayListID]&lookInField=PlayListID&returnField=PlayListType] > [!]> [/!]&DateCreated=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value=[PlayListID]&lookInField=PlayListID&returnField=DateCreated][!]> [/!]&rating=[LOOKUP> db=[pagePath]databases/ > yyy > .db > &value > = > [PlayListID > ]&lookInField=PlayListID&returnField=rating]&MyRating=[search> db=[pagePath]databases/ > xxx.db&eqStoryIDdatarq=[PlayListID]&eqUserIDdatarq=[GETCOOKIE> name=xxx]][founditems][TheRating][/founditems][/search][/replace]>> [/founditems]> [/search]>> -> then I have to do two more seraches. One for the results and one> for next/prev>> [search > table > = > MyPlayListData > &gePlayListIDData > = > 0 > &eqalbumIDdatarq > = > 303 > &PlayListIDsumm > = > T > &[SB]sort=1&[SB]sdir=[SO]&[SB]type=[SB_type]&startAt=[startat]&max=10]>>> I know I can make this code more streamlined, but I am not sure if it> is the tables that are a problem.>> Without a load, these pages work great, but with the increased> traffic, it now takes - well WAY too long to load a page. Anyway, I am> going through and make my code thinner, as it were - I can get rid of> a bunch of the lookups above and replace with another search, but I am> wondering if I should replace all the tables in the site with a temp> .db.>> Any thoughts? or advice? Thanks in advance.>> D.>>> -- > David Bastedo> Ten Plus One Communications Inc.> http://www.10plus1.com> 416.603.2223 ext.1> ---------------------------------------------------------> This message is sent to you because you are subscribed to> the mailing list .> To unsubscribe, E-mail to: > archives: http://mail.webdna.us/list/talk@webdna.us> old archives: http://dev.webdna.us/TalkListArchive/
Rob
DOWNLOAD WEBDNA NOW!
Top Articles:
Talk List
The WebDNA community talk-list is the best place to get some help: several hundred extremely proficient programmers with an excellent knowledge of WebDNA and an excellent spirit will deliver all the tips and tricks you can imagine...
Related Readings:
The Guru Speaks-very long reply (1998)
2 HTTP Servers on one machine (2006)
Running 2 two WebCatalog.acgi's (1996)
Problems getting parameters passed into email. (1997)
Emailer Erreur 551 (2001)
RE: 2nd WebCatalog2 Feature Request (1996)
[AppendFile] problem (WebCat2b13 Mac .acgi) (1997)
RE: protect tag on NT (1997)
Date Sorting (1997)
Is this possible in simple search? question? (1998)
Force leading zeros (1998)
[OT] Bad Hard Drive? (2003)
Generating unique SKU from [cart] - FIXED! (1997)
Cancel Subscription (1996)
Running _every_ page through WebCat-error.html (1997)
SSL and reg web* (1997)
WebCat2.0 [format thousands .0f] no go (1997)
Combining search criteria in a context? (1998)
getchars broken? (1997)
[SearchString] problem with [search] context (1997)