Posts by joewazen

Hello,

can anyone help me find a document explaining a general way to design "Live" tables in SQL?

i have an application linked to a db that contains live tables in it (tables that have records always updated, inserted, deleted and many applications read/write in it)

my biggest worry is to keep those tables clean and light in order not to have deadlocks, long waits, slowness...

Thanks a lot for the reply

1. i am using sp_spaceused to get the DB size That's how i got the average growth per day 60 MB
2. what i need to know is that if my DB is growing by 60 MB/day, is it healthy to keep the default Auto Growth value of SQL 2005 which is 1MB? or do i need to adjust that? or do i need to increment the unused data size manually? i am just trying to find the proper way to keep my SQL Fast and Healthy

Thanks again for the reply and for the negative impact on the read speed hint because i didn't know there was drawbacks

Hello,

I have a 4 GB DB on SQL 2005 and the same on on sql 2008 that is growing 60MB per day, My concern is that should i allocate an unused space to the DB so that the DB wont create space for itself everyday (load on the server), what should be the size of the unused space for my DB

indeed Java Methods that allow me to update my application upon DB update is what i am looking for because i don't want to ask my application to check for updates every x minutes disregarding weather there are updates or not, its a big load on my server, if you can direct me where to look at in Java because im kinda lost while searching in JAVA.

thanks again

Hello MxDev,
thank you for the quick reply but the thing is that my problem is not how the retrieve data from the DB table, its that after doing that i want my application to detect automatically if chenges have been made to the related data and reflect those changes in my app.
Regards,

Hello,

I have an interface containing a table, i need to link that table to the DB Table so that it will automatically reflect the changes done in the DB Table to the Interface table. i.e: if someone (manually or another WEB Application) updated the DB table i want the changes to appear on my interface automatically

Thanks in advance

Hello,

I am thinking of using a partitioned view in my database but i am not being able to find whether it will affect other normal views i.e. if i have a view 'A' consisting of many tables/views and then i partitioned one of the tables into several tables joined by a partitioned view 'B', would that effect the performance of the original view 'A'?

i found a way in tomcat to limit the number of users, you either limit in tomcat administrator based on the virtual directory you created or you can manually add it in WEB-INF/Web.xml

your welcome. the problem was with the table name with using '"+tablename+"' instead of "+tablename+" which made the insert statement insert into 'tablename' instead insert into tablename. please post it as solved.

String DataEntry_TableName = "t1";

query = "insert into "+DataEntry_TableName+" (NameA) values ('"+NameA+"')";

if this didn't work then print the exception and post it please.

Hello,

I have many jsp applications connected to Apache Tomcat 5 and IIS 6 i need to find a way to limit the number of active users in each application either in tomcat or in IIS, i know there is a way to configure server.xml in tomcat but will that limit the number of active users in all applications or in each individually?

Thnx

thnx peter i posted here by error so i moved the thread to javascript forum and i explained a little bit more

hello,

i want to open several ie windows but the problem is that when i use window.open only one ieexplorer thread is used no matter how many windows i open which is causing me session time out problems when closing one of the windows so my question is can u please help me find a way to start a new process each time i open a new window?

i am using ie 7 and windows 2003 server

thanks in advance

Joe

hi all,

can you help me find a way to start a new internet explorer window in a new process? for the moment i am using window.open in javascript but its using the same process no matter how many windows i open while what i need is one process for every window

thanks in advance

Joe

first of all thanks guys for the posts :) as for the problem i am not concerned about the security because its an internal application its not going live. but i am sure that there is a way because logically, correct me if i am wrong, its like copy pasting a file from location to location but of course much harder :)

it's not about updates its about downloading fonts and the problem is that user doesn't know where to save them and he cannot work without them that's why i wana make it easy on him and save them automatically

hi all,

i have an html page with a link to a folder that is located on my server the problem is that when i click on that link i want to save the folder directly into a static location (c:\gv-prj\folderName) on the local pc of the user directly without the pop up window of save-as.

i will appreciate it if someone could help

regards,
joe