You're selecting everything from the customers table to add to the report. Is this where the bottleneck is? Do you need to select all of this data?

I think that will only delete the virtual directory. You need to delete the physical directory in the normal Windows fashion.

Ouch. I hope the curry was worth it. ;)

Welcome to my world ;)

Have you created the child controls after creating your control? e.g. something like:

PeopleEditor PeoplePickerControl = new PeopleEditor();
this.Controls.Add(PeoplePickerControl);
base.CreateChildControls();

The following article may be useful: http://msdn.microsoft.com/en-us/library/dd490570.aspx[^]

Have a look at the Windows SharePoint Services Developer Center. http://msdn.microsoft.com/en-us/sharepoint/default.aspx[^] If you've any more specific questions, just ask :)

You should fine all the info in the Java EE Tutorial in the "Using the Timer Service" section. http://java.sun.com/javaee/5/docs/tutorial/doc/bnboy.html[^]

Bulk inserts will probably be the fastest way. Have a look at: http://msdn.microsoft.com/en-us/library/ms188365.aspx[^]

I'd suggest you maintain a table of who log on/off your application and use this as the basis for your solution. Every time someone logs on, add them to the table. Everytime the log off, remove them from the table. You can then do a simple

select

satement to get a list of all the logged on users and display that in a list box.

Since you're using the JDBC-ODBC bridge, the same code will work to connect to almost any database. You just need to change your ODBC datasource connection.

Your best bet would be to have servlets or some other Java based backend (JSF for example) instead of connecting to the database directory from within JSF. You can then use standard JDBC to connect to the database. If you want to connect to SQL Server, the jTDS driver is one of the best.