>When you say the data changes, does the shape actually change? Because all that >matters to analyze is the shape of the data, not the data itself.
Upon further analysis it appears that the data "shape" is different in different periods within the table. That is, some sections have the inverse shape to other sections. So it looked like query times would change over time but actually they are changing because different portions of the table are being accessed. Is it possible to tell sqlite to analyze different sections and keep separate a record for each? >Unlike me, some other people on here are extremely knowledgeable on SQL and >specifically the inner >workings of SQLite - Tell us the full story, we might save you hundreds of >hours. I will try to take advantage of that. Let me see what I am able to say about our system and hopefully come up with some concise and pertinent questions. RP PS: Some administravia; Does anyone know of a way to reduce the posting delay for this list? Is it always like this? Or is it some problem with the gmane site in general? _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
